Is it possible for a single chart to have multiple Y axes scales

C

Chuck

Is it possible to have separate Y-axes scales for each series in an XY graph
and to have a separate Y-axis "line" with tick marks for each series? All
series have a common X-axis.

Y1 Y2 Y3 Y4
| | | | __________
X

I don't want to multiply or divide each series by an arbitrary value so they
can plot against a common Y scale.

Chuck
--
 
V

voodooJoe

only 2 - primary and secondary Ys are available in any one chart
you 'could' layer charts over top of each other - messy and potentially
flammable, but it will work

make all charts the same size
format so only 1 set of X axis values are visible, format the x axis lines
so they are visible
use x axis lines to align all charts with each other

- vdJ
 
C

Chuck

vdj, Thank you very much for your help.
Layering looks promising. Will try it later today. Graph format from one set
of data to another is fairly consistant. Maybe not too much friction between
layers.

Chuck
--
 
C

Chuck

only 2 - primary and secondary Ys are available in any one chart
you 'could' layer charts over top of each other - messy and potentially
flammable, but it will work

make all charts the same size
format so only 1 set of X axis values are visible, format the x axis lines
so they are visible
use x axis lines to align all charts with each other

- vdJ
Thank you. It was a bear to setup, but it works.

Chuck
--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top