Thursday, January 17, 2013

How to Create Stacked Bar Chart


1. Open your spreadsheet program. If you do not have a spreadsheet program, check out the link below for a free trial of Microsoft Excel, which has the appropriate functionality to create stacked bar charts.
2. Populate the spreadsheet with the data for which you want to create a stacked bar chart. Note that you will need to have at least two values for one category in order create a stacked bar chart.
3. Click the 'Insert' drop down menu and select the 'Chart' option. This action will launch the 'Chart Wizard' in a separate window.
4. Click once on the 'Bar' option under the 'Chart type' listings.
Click once on the 'Stacked bar' option under the 'Chart sub-type' listings.
Click once on the 'Next' button.
5. Choose the 'Rows' option on Step 2 of the 'Chart Wizard' window.
Adjust the data range, if necessary, by clicking in the first cell of the range and dragging to the last while holding down the mouse button.
Click the 'Next' button.
6.
Click the 'Next' button on step 3 of the 'Chart Wizard' window.
Choose whether you want the stacked bar chart to appear in the same sheet as the source data or on a new sheet.
Click the 'Finish' button to view your stacked bar chart.

Blogger news