Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can i have 2 scales in one line chart? | Charts and Charting in Excel | |||
Two alternative scales on same chart?? | Charts and Charting in Excel | |||
2 scales in 1 chart | Charts and Charting in Excel | |||
xy chart -- x and y axes scales min and max | Charts and Charting in Excel | |||
"Broken" chart axis for data of different scales | Charts and Charting in Excel |