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!

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!

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" wrote:

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!

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/ChartsH...venScales.html
--
Best Regards,

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


"LouiseD" wrote:

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" wrote:

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!

The link works fine for me. I suggest that you try again.
--
David Biddulph

LouiseD wrote:
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" wrote:

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!