The following sample data produces ten different stacks with two columns each. The first column has the Y2 value stacked over the Y1 value; every other column has the Y3 value stacked over the Y4 value.
To create the chart, type the following into a worksheet:
A1 : X B1 : Y1 C1 : Y2 D1 : Y3 E1 : Y4 A2 : X1 B2 : 1 C2 : 2 D2 : E2 : A3 : B3 : C3 : D3 : 3 E3 : 4 A4 : X2 B4 : 1 C4 : 2 D4 : E4 : A5 : B5 : C5 : D5 : 3 E5 : 4 A6 : X3 B6 : 1 C6 : 2 D6 : E6 : A7 : B7 : C7 : D7 : 3 E7 : 4 A8 : X4 B8 : 1 C8 : 2 D8 : E8 : A9 : B9 : C9 : D9 : 3 E9 : 4 A10: X5 B10: 1 C10: 2 D10: E10: A11: B11: C11: D11: 3 E11: 4
Microsoft Excel 97 for Windows
To create the chart, follow these steps:- Select cells A1:E11. Click Chart on the Insert menu.
- Click the Standard Types tab. Click Stacked Column under Chart Sub-Type. Click Next.
- In step 2 of the Chart Wizard, click the Series tab. In the Series list, click X, and then click Remove.
- Type the following in the Category (X) Axis Labels box:
=Sheet1!$A$2:$A$11
Then, click Next. - Click Next to move to step 4 of the Chart Wizard.
- Click As New Sheet and click Finish.
Microsoft Excel Versions 5.0 and 7.0
To create the chart, follow these steps:- Select cells A1:E11. Point to Chart on the Insert menu, and then click As New Sheet.
- In step 1 of Chart Wizard, click Next.
- In step 2 of Chart Wizard, click Column, and then click Next.
- Click to select either the third or fifth view in step 3 of Chart Wizard, and then click Next.
- In step 4 of Chart Wizard, click the up arrow next to "Use Column(s) for Category (X) Axis Labels" until the number is incremented to 1, and then click Finish.
Microsoft Excel Versions 4.0 and Earlier
To create the chart, follow these steps:- Select the data in cells A1 through E11.
- On the File menu, click New and click Chart in the New dialog box.
- On the Gallery menu, click Column and select the third or fifth option.