Making a Pie Chart

1
Making a Pie Chart

• Step by Step Instructions on using excel to make
  a pie chart.

2
Beginning

• Before a pie chart can be created the right
  information must be gathered.
• For example the school board needs to know the
  number of school age children that live in each
  region.
• First the region must be divided into separate
  areas and the relative figures must be gathered.

3
Children per Area
We can now use these figures to create our graph.
4
Using Excel

• Excels Chart Wizard makes creating charts about
  as easy as it can possibly get. Just let it know
  what is you want to chart, and then its just a
  matter of making a few selections and your chart
  is on the page. To make a chart with Chart Wizard
  (pictured below), follow these steps

5
Steps

• Select the range of data you want to make a chart
  from. You might not want to select the data
  thats available.
• Click the Chart Wizard button in the toolbar.
  This brings up the first Chart Wizard dialog
  box, Chart Type.

6
Step cont.

• Under Chart Type, choose Pie Chart.
• Under Chart sub-type, choose the specific variety
  of that chart type that you want to use. As you
  click each of the visual subtype representations,
  a description of the typical use of that subtype
  appears below it.
• If you want to see what your data would look
  like, click the Press and Hold to View Sample
  button. The sample thats presented gives only an
  approximation of the appearance of the actual
  finished chart, as its crammed into a very small
  area, but it should tell you what you need to
  know in a general sense.

7
Steps cont.

• When youve made your selections about chart
  types, click the Next button. This brings up the
  second Chart Wizard dialog box, Chart Source
  Data.

8
Steps cont.

• This shows a more accurate representation of how
  the finished chart will look. By default, the
  data series is taken from the rows of the
  selected range.
• If you want to view the range of cells that each
  row or column of data is taken from, click the
  Series tab.
• Click the Next button to proceed. This brings up
  the third Chart Wizard dialog box, Click Option.

9
Steps cont.

• Type a title for the chart in the Chart title
  edit box. If you want any text below categories
  on the bottom part of the chart, type it into the
  Category (X) axis edit box.
• If you want any text to the left of the values
  that range from the top to the bottom of the
  chart on the left side, type it into the Value
  (Y) axis edit box.
• Click Next button to proceed. This brings up the
  fourth and final Chart Wizard dialog box, Chart
  Location.

10
Step cont.

• This is the simplest step of all. All you need to
  do is to decide whether you want the chart to be
  included in the worksheet it draws its data from
  or to be created as a separate chart sheet.
  Unless you have a very high-resolution system or
  a very small chart, its usually best to make the
  chart on a separate sheet. If you try to put a
  large chart on the same worksheet as the original
  data, its usually difficult to fit both so that
  theyre readable. Click the approximate radio
  button, and then click the Finish button.
• The chart is created. If its on the original
  worksheet, Excel places the chart right smack in
  the middle of the worksheet and you have to move
  it manually as well as resize it so that all the
  data is shown. To move it, place the pointer
  anywhere within the table (so long as it isnt
  over a table element such as the title), hold
  down your mouse button, and drag it to its new
  location. To resize it, click any of the sizing
  handles around the edge and drag the handle in
  the direction you want to increase the size.
• To change the font, right click on the text and
  then go to the Font Tab and make your selection.

11
Step cont.

• In order to place your graph and table into Word,
  copy the graph from excel and paste it directly
  into Word.
• This a sample graph using the corresponding
  information for the earlier example.

12
Finished Graph
13
Works Cited

• Willett, Edward. Office 2003 Bible. Indiana
  Wiley Publishing, Inc. 2004