Thursday, February 14, 2013

How to Create a Stacked Chart in Excel 2003


1. Enter your data in column 'A,' with the label for the data in cell 'A1,' and each data value put into cells 'A2,' 'A3' and so on, until you've entered all of the data needed for the chart.
2. Select the range of cells from cell 'A1' through the last cell with a data value in it.
3. Click the 'Insert' menu and select 'Chart.' This will start the Chart Wizard.
4. Click 'Column' for the Chart Wizard from the options under 'Chart Type.' A 'Chart sub-type' menu will show up.
5. Click '100% Stacked Column' and click 'Next.' This selects the stacked chart subtype.
6. Click 'Rows' on the next window of the wizard; this tells where the series data will be imported. Click 'Next.'
7. Clear the check box for 'Show Legend' and add your labels for the chart. Click 'Finish.'

Blogger news