View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default 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