ExcelBanter - Can excel create 4 Y-axis graphs?

You could probably fake it with VBA, but I'm not well versed enough to
tell you how.

Excel does support a second X & Y axis. You can achieve the same
effect by factoring the values to be plotted. For instance parameter A
goes from 0-6, B from 0-1200, C from 0-5, D from 0-100. Insert helper
column E to multiply A by 200 and helper col F to multiply C by 20.
Set the primary Y axis as 0-1200, and plot E & B against it, with the
label for E as "A*20." Likewise set the secondary Y axis scale 0-100,
and plot F & D with F labeled as "C*20."

Not as elegant, but it gets the job done.

If you create on a worksheet (not in a separate chart page) dummy
charts with the Y axis scaling you want, you could line these up,
"parking" successive charts on top these with the chart above on top.
This would then provide the appearance of what you want. Then you
wouldn't have to do the funny labelling, although you would still need
to plot the helper columns as noted above sine the actual plotting is
done on the singel chart.

HTH

---GJC

--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=528466