Microsoft KB Archive/213929

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

Article ID: 213929

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q213929



For a Microsoft Excel 98 and earlier version of this article, see 151353.

IN THIS TASK
SUMMARY
 * Create Stacked Column Chart
 * Create Stacked Bar Chart



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:  Start Excel, and then create the following worksheet:

A1: Data

A2: 100

A3: 300

A4: 650

A5: 425

A6: 175

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

back to the top

Create Stacked Bar Chart
To create a single stacked bar chart, follow these steps: <ol> Start Excel, and then create the following worksheet:

A1: Data

A2: 100

A3: 300

A4: 650

A5: 425

A6: 175

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

back to the top

Keywords: kbhowto kbhowtomaster kbualink97 KB213929

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.