Chart with 3 data scales

[Guest]

I have a table as follows:

A B C D
1 Sales Units Profit
2 Branch 1 10,000 200 10%
3 Branch 2 20,000 100 12%
4 Branch 3 30,000 900 17%

I want a chart showing

Sales and Units as bar on two different vertical axis. Regarding the Profit
rate, it should be reflected as a line with points showing the levels.

Problem is that all three parts are quite of different scale and can't be
put on a single line!

Thanx & regards,

FARAZ

 

[Jon Peltier]

You can fake a tertiary axis:

http://peltiertech.com/Excel/Charts/TertiaryAxis.html

but less confusing for the reader is a panel chart:

http://peltiertech.com/Excel/Charts/StackedCharts.html
http://peltiertech.com/Excel/ChartsHowTo/PanelUnevenScales.html

- Jon