Saturday, June 15, 2013

How to Create a Multiple Stacked Chart in Excel 2003


1. Open your Microsoft Excel spreadsheet filled with your data sets.
2. Click your cursor on the 'A1' cell. Hit the 'Control' ('Ctrl') button and then press the 'A' key without letting go of the 'Control' button. You will see the cells where you have typed your data become highlighted. Keep in mind that you need at least two sets of data to create a stacked column chart.
3. Click 'Insert' on your toolbar.
4. Click Column. Select one of the 'stacked' column styles. You can choose, for example, a cylindrical stacked column or a conical stacked column. Excel will turn your data into a chart, and that chart will appear on your screen.

Blogger news