LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default can i have 2 scales in one line chart?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I add two vertical scales to a line graph? IronRobbie Charts and Charting in Excel 1 June 12th 07 02:46 AM
Two alternative scales on same chart?? Dabears70 Charts and Charting in Excel 1 April 27th 07 01:26 AM
2 scales in 1 chart Sirritys Charts and Charting in Excel 3 September 21st 06 03:35 PM
Line chart with multiple scales/units along an axis... JohanD Charts and Charting in Excel 3 March 19th 06 04:53 AM
Scales of Column and Line Graphs [email protected] Charts and Charting in Excel 1 March 3rd 06 03:47 AM


All times are GMT +1. The time now is 05:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"