Chart with 3 data scales
 

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

Chart with 3 data scales
 

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"FARAZ QURESHI" wrote in message
...
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