Pie Chart



1. Create Chart

Enter Data

Type out 4-6 things about what you like to do on the weekends or during the week. You want to have a range that's reasonable (not too much difference between the high and low values). 

You can make column A wider by hovering your mouse over columns A & B...

... then click and drag when it over...

Save

At this point make sure you save it! If something goes wrong with the pictures, you can at least go back to this part instead of having to start over.

Go to File>Save... or use the keyboard shortcut CTRL+S... then click on Browse...

Then go to This PC >... go into your Z: folder an then into your "Computers" folder - give it the name "Pie chart" and save it.

Select the data

You need 2 columns of data, no empty columns or rows. Do not select the heading row! Click and drag starting with the first item and then over (just the 2 columns) and down to the last item (no empty rows).

Insert chart

Go to the INSERT toolbar and select "Pie" (normal 2D or 3D) type of chart.

When you do this, you should see a pie chart pop up, something like this...


2. Chart Design

Move chart

When you let go, you should see a pie chart in your sheet. Go to the right of the DESIGN tab and click on Move Chart.

A new dialog box opens up. Click on the radio button for the top choice, "New Sheet" and give it a name.

You'll now be in the new sheet with the chart.
The chart is in its own sheet but if you ever want to get back to the data sheet, look at the bottom tabs.

Zoom out - click on the "-" a couple times so you're at 90%...

Quick Layout

Under the DESIGN tab, go to Quick Layout and choose the one with the title, label and percentage. 

If you don't see the CHART TOOLS tabs at the top, click anywhere in the empty chart area...

Chart Styles

Go to Chart Styles and use the drop-down menu...

Choose the one where the labels and percentages are outside the pie chart.

So far you have something like this...

3. Format Text

Chart Title

  1. Click in the chart title box.
  2. CTRL+A to select all the text in it and type out your title.
  3. [Enter] to the next line.
  4. Type out your name. 
  5. Select just the title and change the font type to something more unique/fun. 
  6. Then pump up the size so it really stands out

Lastly, give it a style (under the FORMAT tab)...

So you have something like this...

Data Labels

Click on any of the data labels and they'll all be selected and then...

  1. Change the font type to Bookman Old Style
  2. Make it not bold
  3. Change the color so they're all black and 
  4. Pump it up to size 12

At this point make sure you save it! If something goes wrong with the pictures, you can at least go back to this part instead of having to start over.

Insert Pictures

Find a picture

In another tab in Chrome, find a picture you want to use for that piece of the pie, right-click on the picture and "Copy Image".

Paste first picture

Click on the chart once, then click on one piece of the chart. You will know it is selected if you see small circles in the center and corners of that piece of the chart.

Then paste in the picture by using the keyboard shortcut CTRL+V.

Do the same for each piece of the pie chart. 

  1. In Chrome, find a picture and right-click "Copy Image".
  2. In Excel, select just the piece of the pie you want to put it into.
  3. Then CTRL+V to paste it inside.

You should end up with something like this...


Demos


Enter data

Create chart

Move chart

Format chart

Chart title

Data labels

Paste first pic