Take a look at Jon's article on panel charts with different axis. It's a bit
of work, but it results in chart that does what you ask, plot 3 different
axis over time.

http://peltiertech.com/Excel/ChartsH...venScales.html
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"LouiseD" wrote:

I want to graph: sales, % increase, and sales per square foot over time (5
years. How do I show 3 different sets of information on 1 graph? So far I
have sales as a bar, % as a line graph on top but I need sales psf in the
background. The axes would need very different numbers. thanks!