3 graphs in 1?

[LouiseD]

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!

 

[Luke M]

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/ChartsHowTo/PanelUnevenScales.html

 

[LouiseD]

That link does not seem to exist. I tried going to the peltiertech site and
working my way in to Excel and 'charts how to' but there is no
PanelUnevenScales. hmmm...

 

[Luke M]

Odd, it works when I click on it. However, navigativing Jon's site from
"Charts"

(Just search for each phrase on web page to find link)

Chart Types Not Native to Excel
Stacked Charts With Vertical Separation.
Panel Charts with Different Scales

I'll post shortcut again, just in case.
http://peltiertech.com/Excel/ChartsHowTo/PanelUnevenScales.html