DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 213929 - Last Review: September 27, 2003 - Revision: 3.1

This article was previously published under Q213929

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.

APPLIES TO
  • Microsoft Excel 2000 Standard Edition
Keywords: 
kbhowto kbhowtomaster kbualink97 KB213929
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support