M
Martin.mcnulty
I can't find a way to plot graphs with x2 axis (i.e. where one set of data is in hundreds and the other is in thousands)
Please help
Please help
J
June Low [MSFT]
Hi Martin 
The only way I could find to add a second axis to a chart is to select a
data series within the chart and then selecting another chart style to plot
that particular data series in. Then, in the Formatting Palette, look in the
Chart Options pane in the Axes section, the Secondary Vertical/Horizontal
Axis buttons will be enabled.
I could not discover how to enable the second axis while keeping the same
chart style. Hopefully someone with more Excel and chart expertise will be
able to help.
-June
OfficeArt Tester, MacBU
Microsoft
The only way I could find to add a second axis to a chart is to select a
data series within the chart and then selecting another chart style to plot
that particular data series in. Then, in the Formatting Palette, look in the
Chart Options pane in the Axes section, the Secondary Vertical/Horizontal
Axis buttons will be enabled.
I could not discover how to enable the second axis while keeping the same
chart style. Hopefully someone with more Excel and chart expertise will be
able to help.
-June
OfficeArt Tester, MacBU
Microsoft
T
Tim G
Hi. You can select a data series, right click and select "format data series". One of the options should be "Axes". You can then define whether it is primary or secondary content. The challenge is that the two different data series now overlap each other when presented rather than sitting next to each other.