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