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

This article was previously published under Q213929
This article has been archived. It is offered "as is" and will no longer be updated.
For a Microsoft Excel 98 and earlier version of this article, see 151353.

IN THIS TASK

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
Properties

Article ID: 213929 - Last Review: 12/05/2015 12:24:47 - Revision: 3.1

Microsoft Excel 2000 Standard Edition

  • kbnosurvey kbarchive kbhowto kbhowtomaster kbualink97 KB213929
Feedback