Excel Basics:

Title: Jan's Illustrated Computer Literacy 101
Did you want Working with Numbers: 2007,2010,2013,2016  or españolIcon: Change web

Numbers do not make the same impact on the brain as a picture. A chart is not only prettier than a list of numbers, it actually is a better way to show you how the numbers compare. 

Chart: PieFrom a pie chart you can immediate tell when certain items take up a big part of the pie.
Chart: BarFrom a bar chart you can easily see which items are larger than the rest.

Where you are:
JegsWorks > Lessons > Numbers

Before you start...

Project 1: Excel IntroTo subtopics

Project 2: Excel Basics  
Getting StartedTo subtopics      
    ArrangeTo subtopics  
    AutoFillTo subtopics  
    Finish arrow to open subtopics
    Icon - FootprintChart
    Icon - FootprintPrint-Defaults reference table
    Icon - FootprintPrint-Options
    ExercisesTo subtopics

Project 3: Format & ArrangeTo subtopics

Project 4: Groups & FormulasTo subtopics

Project 5: DesignTo subtopics


Icon Step-by-Step 

Step-by-Step: Pie Chart

 Icon Step-by-Step

What you will learn:

to use the Chart Wizard to create a pie chart
to add category labels from cells

Start with: Class disk trips7.xls (saved in previous lesson)

  1. Select range A27:A35, hold down the CTRL key, and drag to select range C27:C35. Both ranges are now selected. These are the row labels and the data cells for the number of people who bought trips each week.
  2. Click on Button: Chart the Chart Wizard button. The chart wizard opens.
  3. Chart Wizard Step 2Select the Pie chart type and click the Next button. Step 2 of the Chart Wizard opens. Hmmm. The wedges do not appear to match the # of people numbers. Something is wrong here.

    Bar chartProblem: The first column you selected is the row labels. The labels are numbers instead of text. Excel has gotten confused and is trying to use the labels as a second series of data to chart. It would be very noticeable if you had chosen a bar graph since you would have 2 sets of bars but no labels. You can fix this problem!

  4. Look at the Data range shown. It lists all ranges to be charted.Data range includes labels


    TipThe sheet's name is separated from the range with an exclamation point !, which you can read as "bang".

  5. Chart Wizard Step 2 - SeriesClick on the Series tab. The Category Labels box is blank when it should show the Week range.
  6. With the Series Week selected on the left, click the Remove button.
  7. Click in the text box Category Labels. 
  8. Click on Button: Collapse dialog the Collapse Dialog button at the end of the Category Labels text box, so you can see your data cells. 

  9. Dialog-Chart Wizard- Step 2 - Series correctedDrag on Sheet1 from A28 to A35. The range you selected appears in the text box.
  10. Click on Button: Restore Dialog the Restore Dialog button to open the dialog back up.  Now you are ready to format the chart.

    Alternate: You could have just typed in the range for the Category labels. Or you could have copied the range before you removed the Week series and then pasted into the Category labels text box. You would have wound up with an extra legend item - Week- unless you edit the range to start with A28 instead of the original A27. But then, you would not had such fun with the Collapse and Restore Dialog buttons! 

  11. Click the Next button. Step 3 - the Chart Options- opens. The Chart Wizard automatically makes the title the same as the column label you selected and puts the legend on the right. You could change those on the Titles and Legend tabs, but the defaults are just fine this time.
  12. Switch to the Data Labels tab, if necessary, and click on Show percent (Icon: Excel 2003 Percentage) to label each wedge of the pie. The Show leader lines box should be checked.

    Dialog: Chart Wizard Step 3 - Data Labels

    Tip The first item in the legend always has its left edge at the top center. The next item is to its right, clockwise.

  13. Click the Next button. Step 4 - Chart Location- opens. You have two choices for where to put the chart you are creating: As new sheet and As object in.  

    The As new sheet choice creates a new worksheet in your workbook. The chart will take up the whole sheet. This automatically gives you the largest size on screen with the whole chart visible at once. The chart will automatically print as large as will fit on the piece of paper. This is wonderful, except that it can be too big for charts with only a few items.

    The As object in choice lets you place the chart on an existing sheet. For small charts you might want to have the chart on the same page as the data. You can add other charts, data, or text easily to a sheet. 

  14. Dialog - Chart Wizard- Step 4Select As object in and drop the list. Choose Sheet 2. 
  15. Click on the Finish button. The chart is created and placed in the middle of the screen on Sheet 2. The size of the chart depends on the size of your document window.
  16. Drag the chart to the upper left of the sheet.
  17. Click outside the chart to unselect it.
  18. Double-click the Sheet2 tab at the bottom and retype the name as  Pie Chart  and press ENTER. The tab now shows the new name. 
  19. Class diskSave As  trips8.xls .
    full floppy diskHow to handle a full disk

    Chart of # of People

LessonsWorking with Numbers Previous Page Next Page

Teachers: Request permission to use this site with your class

Copyright © 1997-2012 Jan Smith   <jegs1@jegsworks.com>
All Rights Reserved

Icon: DonwloadIcon: CDWant a local copy with no ads? - Download/CD
Want to help?

~~  1 Cor. 10:31 ...whatever you do, do it all for the glory of God. ~~

Last updated: 02 May 2012