#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default Chart Scale

Is it possible if I have 2 charts in one, both with different scales (1st one
-50 to 200 and the 2nd one 1000 to 1500) to take out from the y-axis part of
the scale, say for example, take out from 210 to 900, so overall i have a
clearer chart, with a scale -50 to 200 and then 1000 to 1500????

Thanks for the help.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,069
Default Chart Scale

have a look here http://peltiertech.com/Excel/Charts/axes.html. these might
help
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"chelo" wrote:

Is it possible if I have 2 charts in one, both with different scales (1st one
-50 to 200 and the 2nd one 1000 to 1500) to take out from the y-axis part of
the scale, say for example, take out from 210 to 900, so overall i have a
clearer chart, with a scale -50 to 200 and then 1000 to 1500????

Thanks for the help.

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default Chart Scale

I had a look, but did not find exactly what I need. Do you know how to do it??
Thanks for your help



"John" wrote:

have a look here http://peltiertech.com/Excel/Charts/axes.html. these might
help
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"chelo" wrote:

Is it possible if I have 2 charts in one, both with different scales (1st one
-50 to 200 and the 2nd one 1000 to 1500) to take out from the y-axis part of
the scale, say for example, take out from 210 to 900, so overall i have a
clearer chart, with a scale -50 to 200 and then 1000 to 1500????

Thanks for the help.

Reply
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 set up a chart with the scale as 1a, 1b, 2a,2b, 3, 4, 5 sam_allenuk Charts and Charting in Excel 2 February 7th 07 03:41 PM
How to draw chart: log scale on X axis, natural scale on y axis? Pratap D. chavan Charts and Charting in Excel 1 November 16th 06 08:03 AM
chart scale Gia Charts and Charting in Excel 1 June 30th 06 05:42 AM
Huge differences in chart values screws my bar chart scale up. Sirritys Charts and Charting in Excel 2 June 13th 06 10:33 AM
Scale in a chart tony Charts and Charting in Excel 1 May 20th 06 01:27 AM


All times are GMT +1. The time now is 03:39 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"