Y-axe Multiscale charting

[Javier]

Hi all, I have to plot 4 series in an excel chat but the values between
series are too diferent to see it well.

Does anybody know how to plot it in a chart in some kind of multiscale Y-axe?

My values are

serie 1: 36-37-36-30-12-11
serie 2: 100345-134583-123908-290874-234986-13456
serie 3: 105-562-148-489-98-255
serie 4: 1.5-3.4-2.3-5.6-4.3-2.5

I only see well serie 2
Thanks in advance

 

[Andy Pope]

Hi,

Looks like you need to move the series 2 data to the secondary y axis.
Double click the series and choose Secondary axis on the Axis tab.

Cheers
Andy

 

[James Silverton]

Javier wrote on Tue, 29 Nov 2005 07:30:04 -0800:

J> Does anybody know how to plot it in a chart in some kind of
J> multiscale Y-axe?

J> My values are

J> serie 1: 36-37-36-30-12-11
J> serie 2: 100345-134583-123908-290874-234986-13456
J> serie 3: 105-562-148-489-98-255
J> serie 4: 1.5-3.4-2.3-5.6-4.3-2.5

A pretty good case for a logarithmic y-axis in a real graph
(scatter). I've tried you data and it works well.

James Silverton.

 

[Javier]

Thanks Andy, is there only secundary y axis, nor third or fourth y axis?

 

[Andy Pope]

Hi,

If you don't mind a little construction work Jon Peltier explains how to
add additional y axis.
http://peltiertech.com/Excel/Charts/TertiaryAxis.html

Cheers
Andy