Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
text box that will leave only the last 4 digits entered | Excel Discussion (Misc queries) | |||
How do I split a y axis in order to display extreme values? | Charts and Charting in Excel | |||
Auto Display of X and Y axis values for multiple charts in WKBK | Charts and Charting in Excel | |||
category axis doesn't display values | Charts and Charting in Excel | |||
Display Values under Date labels on the X-Axis... | Charts and Charting in Excel |