Is it possible to have multiple verticle axis with different scales?

  • Thread starter Thread starter Tino
  • Start date Start date
T

Tino

Hi,

I'm doing a line graph and would like to show two series of data on
the one graph.

My problem is that the two data series are at very different scales...
one is percentage and the other is quantity sold.

Is it possible to have a graph with two axes, one for each data
series?

Any help would be much appreciated.

Thanks
 
Hi,

I'm doing a line graph and would like to show two series of data on
the one graph.

My problem is that the two data series are at very different scales...
one is percentage and the other is quantity sold.

Is it possible to have a graph with two axes, one for each data
series?

Any help would be much appreciated.

Thanks
Click to expand...

Yes you can do that. Select the series you want to use a different axis
with. Right click on it and select Format Data Series, then select Axis,
and finally click Secondary Axis. Voila, adjust the min and max etc. on
the right hand axis to your liking.

Norm

Father Guido
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
I plan on living forever... so far, so good
 
-----Original Message-----
Hi,

I'm doing a line graph and would like to show two series of data on
the one graph.

My problem is that the two data series are at very different scales...
one is percentage and the other is quantity sold.

Is it possible to have a graph with two axes, one for each data
series?

Any help would be much appreciated.

Thanks

.
Click to expand...

If click on the data row with the right mouse button and
then on "format row" under the topic axis you can activate
a secondary axe. I don´t know if you can give it a
different format then the first axe but you can try.
I hope I could help you.

Matthias
 
I'm doing a line graph and would like to show two series of data on
Again, the original post never appeared on my server...

Select the data series that you want on the secondary axis by clicking on
that series. On the menu, Format | Selected data series | Axis tab. Select
the secondary axis and you should be on the way.

Dave
dvt at psu dot edu
 
Back
Top