HOW TO: Create a Single Stacked Column Chart or Single Bar Chart in Excel 2000 (213929)

SUMMARY

This step-by-step article explains how to create a single stacked column chart and a single bar chart in Microsoft Excel 2000. these kinds of charts.

back to the top

Create Stacked Column Chart

To create a single stacked column chart, follow these steps:

1. Start Excel, and then create the following worksheet:

   A1: Data
   A2: 100
   A3: 300
   A4: 650
   A5: 425
   A6: 175

2. Select cells A1:A6.
3. On the Insert menu, click Chart.
4. In step 1 of the Chart Wizard, click Column under Chart type.
5. Under Chart Sub-type, click 100% Stacked Column (first row, third column), and then click Next.
6. In step 2 of the Chart Wizard, click Rows next to Series in, and then click Next.
7. In step 3 of the Chart Wizard, clear the Show legend check box on the Legend tab.
8. Click Finish.

back to the top

Create Stacked Bar Chart

To create a single stacked bar chart, follow these steps:

1. Start Excel, and then create the following worksheet:

   A1: Data
   A2: 100
   A3: 300
   A4: 650
   A5: 425
   A6: 175

2. Select cells A1:A6.
3. On the Insert menu, click Chart.
4. In step 1 of the Chart Wizard, click Bar under Chart type.
5. Under Chart Sub-type, click 100% Stacked Bar (first row, third column), and then click Next.
6. In step 2 of the Chart Wizard, click Rows next to Series in, and then click Next.
7. In step 3 of the Chart Wizard, clear the Show legend check box on the Legend tab.
8. Click Finish.

back to the top