Plotting a chart on two axis

L

Luke Dodimead

I am trying to plot a line chart on two axis with more
than two series. e.g. series 1 = price, series 2 = %,
series 3 = %, series 4 = %. Excel decides which series is
plotted against which axis, how can I determine this
instead?

Thanks
Luke
 
G

gurs

Luke said:
*Excel decides which series is
plotted against which axis, how can I determine this
instead?*
Click to expand...

Right-click on the series, select "Format", then select the "Axis" ta
and you can choose against which axis that series will plot
 
J

Jon Peltier

Luke -

Draw the chart with all series on the same axis, then double-click on
one that you want on the secondary axis. On the Axis tab, select
Secondary. Select the next to change, and press F4 to repeat. Continue
to repeat as needed.

If you design your own combination chart like this, Excel doesn't try to
guess how you want it.

- Jon
 
Top