1. Home
  2. Computing & Technology
  3. Spreadsheets

Create a Bar Graph in Excel

By Ted French, About.com

10 of 10

Chart Tutorial Data

Enter the data below in the cells indicated to create the bar graph covered in this tutorial. There is no worksheet formatting covered in this tutorial, but that will not affect your bar graph.

Cell - Data
A1 - Income Summary - The Cookie Shop
A3 - Total Revenues:
A4 - Total Expenses:
A5 - Profit/Loss:
B2 - 2003
B3 - 82837
B4 - 57190
B5 - 25674
C2 - 2004
C3 - 83291
C4 - 59276
C5 - 26101
D2 - 2005
D3 - 75682
D4 - 68645
D5 - 18492

Return to Step 2 of this tutorial.

  1. Bar Graph Step by Step Tutorial
  2. Step 1 - Entering the Chart Data
  3. Step 2 - Select the Graph Data
  4. Step 3 - How to Start the Chart Wizard
  5. The Excel Chart Wizard — Step 1
  6. The Excel Chart Wizard — Step 2
  7. The Excel Chart Wizard — Step 3
  8. The Excel Chart Wizard — Step 4
  9. Formatting the Bar Graph
  10. Chart Tutorial Data

<< Previous | Next

10 of 10

Index: Create a Bar Graph in Excel

    Explore Spreadsheets

    More from About.com

    1. Home
    2. Computing & Technology
    3. Spreadsheets
    4. Spreadsheet Lesson Plans
    5. Bar Graph - Create a Bar Graph - Example Bar Graph

    ©2008 About.com, a part of The New York Times Company.

    All rights reserved.