XL: How to Create a Single Stacked Column or Bar Chart
ID: Q151353
|
The information in this article applies to:
-
Microsoft Excel 98 Macintosh Edition
-
Microsoft Excel 97 for Windows
-
Microsoft Excel for Windows 95, versions 7.0, 7.0a
-
Microsoft Excel for Windows, versions 2.0, 2.01, 2.1, 2.10c, 2.10d, 3.0, 3.0a, 4.0, 4.0a, 5.0, 5.0c
-
Microsoft Excel for the Macintosh, versions 2.20, 2.2a, 3.0, 3.0a, 4.0, 5.0, 5.0a
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.
In Microsoft Excel Versions 5.0 and 7.0
- 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, point to Chart, and then
click On This Sheet or As New Sheet. Click Next.
- Click Column in the "Select a chart type" dialog box, and then click
Next.
- Click either view 3 or 5 in the "Select a format for the Column
chart" dialog box, and then click Next.
- In the Sample Chart box, under "Data Series in," click Rows and
then click Next.
- Click No under "Add a Legend?" and click Finish.
In Microsoft Excel Versions 4.0 and Earlier
- Enter the following in a spreadsheet:
A1: Data
A2: 100
A3: 300
A4: 650
A5: 425
A6: 175
- Select the cells that contain the data points.
- On the Edit menu, click Copy.
- On the File menu, click New, and then click Chart.
- In the Chart window, click Paste Special on the Edit menu.
- Click Rows under Values In.
- Click OK.
- For a stacked Column chart, click Column on the Gallery menu. For a
stacked Bar chart, click Bar on the Gallery menu.
- Click on chart type 3 or 5, depending on the column or bar chart
type you want.
Additional query words:
5.00a 5.00c 8.00 97 98 XL98 XL97 XL7 XL5 XL4
Keywords : kbtool kbualink97 xlchart
Version : MACINTOSH:2.20,2.2a,3.0,3.0a,4.0,5.0,5.0a,98; WINDOWS:2.0,2.01,2.1,2.10c,2.10d,3.0,3.0a,4.0,4.0a,5.0,5.0c,97; Win95:7.0,7.0a
Platform : MACINTOSH Win95 WINDOWS
Issue type : kbhowto kbinfo
|