How to Create Stacked Bar Graphs in Excel

Written by art corvelay
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Create Stacked Bar Graphs in Excel
(Siri Stafford/Digital Vision/Getty Images)

Excel is a proprietary spreadsheet application created by Microsoft. This program allows users to enter quantitative data and automatically create different output formats for the data. One function that Excel supports is the ability to output various graphs and charts based on the data entered. Create advanced graphs, such as stacked bar graphs, using the graphing function in Excel.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Launch Excel and open a spreadsheet. Begin entering your data in cell A1 and continue entering data in subsequent cells in row A. For example, if you have four numbers you want to display, enter data in A1, A2, A3 and A4.

  2. 2

    Select the cells you want to create into a stacked bar graph. For example, select cells A1 through A4 if you have four numbers.

  3. 3

    Click "Insert" on the top menu and select "Chart." This will open the Chart Wizard.

  4. 4

    Select "Bar" from the "Chart Type" menu box. Then select "100% Stacked Bar" from the "Chart Subtype" menu. This is the third choice listed. Click the "Next" button to proceed.

  5. 5

    Select the "Rows" option in the "Series in" menu and click "Next."

  6. 6

    Add labels, including names for the chart title, the X axis and the Y axis.

  7. 7

    Click the "Finish" button, and the graph will be automatically generated.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.