like http://www.bunnytimes.com/saveit.JPG
if so, how?
if not, what app could do it?
like http://www.bunnytimes.com/saveit.JPG
if so, how?
if not, what app could do it?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks