Y-axe Multiscale charting
 

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

Y-axe Multiscale charting
 

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

Javier wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

Y-axe Multiscale charting
 

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.

Y-axe Multiscale charting
 

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

"Andy Pope" wrote:

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

Javier wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

Y-axe Multiscale charting
 

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

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

"Andy Pope" wrote:


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

Javier wrote:

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, Microsoft MVP - Excel
http://www.andypope.info


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info