Plotting a chart on two axis

  • Thread starter Thread starter Luke Dodimead
  • Start date Start date
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
 
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
 
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
 
Back
Top