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

Article translations Article translations
Article ID: 213929 - View products that this article applies to.
This article was previously published under Q213929
Expand all | Collapse all

On This Page

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.

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.

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.

Properties

Article ID: 213929 - Last Review: September 27, 2003 - Revision: 3.1
APPLIES TO
  • Microsoft Excel 2000 Standard Edition
Keywords: 
kbhowto kbhowtomaster kbualink97 KB213929

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com