Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Dear All.
I want like to display a line chart (with markers) for the following data: Sales/Period Year 04 Year 05 Year 06 Year 07 Country A £2,000 £2,100 £2,200 £2,300 Country B £800 £850 £900 £950 Country C £780 £830 £880 £930 Country D £750 £800 £850 £900 The problem is that countries B, C, and D have very similar amounts. So in the chart the lines correspondent of these countries are very close. My idea was to set up different scales in the Y axis, so i can see more space between the lines. I know that one of the solutions is to use secondary axis. But by doing that, its not "user friendly" to read the data... What i really want to do is in the same axis (primary) have 2 different scales. Could you please help me with this? Kind Regards CB |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I add two vertical scales to a line graph? | 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 | |||
Line chart with multiple scales/units along an axis... | Charts and Charting in Excel | |||
Scales of Column and Line Graphs | Charts and Charting in Excel |