Microsoft KB Archive/68661

Creating a PowerPoint Chart with Two Vertical Axes PSS ID Number: Q68661 Article last modified on 10-29-1991 PSS database name: W_PowerPt

2.00

WINDOWS

Summary:

Although there is no option to automate the process, it is possible to create a chart with two vertical axes using PowerPoint’s embedded Graph program. To do this, you must create two separate charts – one containing the left-hand axis and all the data, and the other consisting of only the right-hand axis. After they have been created and pasted to the slide, you will superimpose the right-hand axis on top of the other chart to create the appearance of a single chart with two axes.

More Information:

To achieve this, perform the following steps:


 * 1) From the File menu, choose Insert Graph.
 * 2) Enter all your data and format the chart to look the way you will want it on the slide.
 * 3) From the File menu in Graph, choose Exit and Return to paste the chart onto the slide in PowerPoint. This is the “main body” of the chart.
 * 4) Start up Graph a second time by choosing Insert Graph from the File menu.
 * 5) Select and clear all the cells in the datasheet. This can be done by clicking the little white square in the top left corner of the datasheet, and then pressing the delete key.
 * 6) Activate the Chart window by clicking the chart.
 * 7) Choose Line Chart style #2 from the Chart menu and click OK.
 * 8) Choose None in the Legend option of the Format menu and click OK.
 * 9) Cancel Show Horizontal Axis in the Horizontal Axis… option of the Format menu.
 * 10) From the Format menu, choose Vertical Axis, and set Vertical Axis Position to Right.
 * 11) In the Format menu under Vertical Axis…, change the Vertical Axis Scaling settings to match those of the vertical axis of the main body of your chart.
 * 12) Choose Exit and Return from the File menu to paste the newly created vertical axis onto your PowerPoint slide. Position the new vertical axis at the right-hand side of the horizontal axis of the chart you created earlier.

When you have the two charts positioned as you want them, you can prevent them from becoming separated by using the following method:


 * 1) Select both charts by pressing the SHIFT key and clicking each chart in turn.
 * 2) From the Edit menu, choose Cut.
 * 3) From the Edit menu, choose Paste as Picture.

Note: This causes the two charts to become a single graphical object that can no longer be broken down into its two composite parts. However, the embedded link to the data sheet is also lost, so the chart cannot be edited except for resizing, recoloring, and cropping.

Copyright Microsoft Corporation 1991.