Microsoft KB Archive/151353

= How to Create a Single Stacked Column or Bar Chart =

Article ID: 151353

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q151353





SUMMARY
In Microsoft Excel, you can create a single stacked column or bar chart.



MORE INFORMATION
To create a single stacked column or bar chart, use the following appropriate steps.

Microsoft Excel 97 and Microsoft Excel 98 Macintosh Edition
 Enter the following in a spreadsheet:

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 the Standard Types tab. Under Chart Type category, click Column. Under Chart Sub-type, click either the third or fifth, and then click Next. In step 2, under Series In, click Rows, and then click Next. In step 3, clear the Show Legend check box. Click Finish.</li></ol>

In Microsoft Excel Versions 5.0 and 7.0
<ol> Enter the following in a spreadsheet:

A1: Data

A2: 100

A3: 300

A4: 650

A5: 425

A6: 175

</li> Select cells A1:A6. On the Insert menu, point to Chart, and then click On This Sheet or As New Sheet. Click Next.</li> Click Column in the "Select a chart type" dialog box, and then click Next.</li> Click either view 3 or 5 in the "Select a format for the Column chart" dialog box, and then click Next.</li> In the Sample Chart box, under "Data Series in," click Rows and then click Next.</li> Click No under "Add a Legend?" and click Finish.</li></ol>

In Microsoft Excel Versions 4.0 and Earlier
<ol> Enter the following in a spreadsheet:

A1: Data

A2: 100

A3: 300

A4: 650

A5: 425

A6: 175

</li> Select the cells that contain the data points.</li> On the Edit menu, click Copy.</li> On the File menu, click New, and then click Chart.</li> In the Chart window, click Paste Special on the Edit menu.</li> Click Rows under Values In.</li> Click OK.</li> For a stacked Column chart, click Column on the Gallery menu. For a stacked Bar chart, click Bar on the Gallery menu.</li> Click on chart type 3 or 5, depending on the column or bar chart type you want.</li></ol>

Additional query words: 5.00a 5.00c 8.00 97 98 XL98 XL97 XL7 XL5 XL4 XL

Keywords: kbhowto kbinfo kbualink97 KB151353

-

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

© Microsoft Corporation. All rights reserved.