If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
3 graphs in 1?
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! |
#2
|
|||
|
|||
3 graphs in 1?
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! |
#3
|
|||
|
|||
3 graphs in 1?
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! |
#4
|
|||
|
|||
3 graphs in 1?
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! |
#5
|
|||
|
|||
3 graphs in 1?
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! |
Thread Tools | |
Display Modes | |
|
|