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