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: 25
Default Adjusting display on Y axis to leave out some digits values.

I have a chart that I use to plot a number of diffferent data series.
Sometimes the numbers I am plotting are small e.g., within the range 0 to 100
and it looks good because the display (y axis) looks
0,10,20,30,40,50,60,70,80,90,100. Sometimes however the data I plot is large
and it dispays 0,100000,20000,300000,400000 etc, which is hard on the eye. Is
there any way that I can leave the display so it looks to the eye like it is
0,10,20 even though it is really referring to 0,10000,20000 etc. (the user
will be able to tell from other info that the amounts are really 10000,20000
etc - so I am not worried about the user thinking it is really 10 and not
10000.

I am not looking to reduce/change the actual numbers being plotted - just
to adjust the DISPLAY so it is easier on the eye so that 10 displays as 10
but 10,000 also disaplys as 10 (in a higher scale environment). Hope I was
able to explain the above clearly.
 
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
text box that will leave only the last 4 digits entered cj2k2k Excel Discussion (Misc queries) 0 June 13th 07 01:06 PM
How do I split a y axis in order to display extreme values? KGB Charts and Charting in Excel 1 November 17th 06 03:27 PM
Auto Display of X and Y axis values for multiple charts in WKBK Barb Reinhardt Charts and Charting in Excel 0 January 11th 06 02:46 PM
category axis doesn't display values Lorraine Charts and Charting in Excel 1 October 17th 05 11:42 PM
Display Values under Date labels on the X-Axis... Bob Barnes Charts and Charting in Excel 1 October 7th 05 10:24 PM


All times are GMT +1. The time now is 01:53 AM.

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"