|
Scale Question regarding 0
My chart is not very clear at this time.
I have a few items of data A, B, C, and D. A has 250 of X. B has 30 of X. C has 0 of X. D has 1 of X. Since 250 is such a large difference from 1, D is almost non-existent. Is there any way to increase the view size of 1? Microsoft 2003. Live User |
Scale Question regarding 0
Hi,
One way would be to break the Value axis. For work around instructions see http://peltiertech.com/Excel/Charts/BrokenYAxis.html Cheers Andy LiveUser wrote: My chart is not very clear at this time. I have a few items of data A, B, C, and D. A has 250 of X. B has 30 of X. C has 0 of X. D has 1 of X. Since 250 is such a large difference from 1, D is almost non-existent. Is there any way to increase the view size of 1? Microsoft 2003. Live User -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| All times are GMT +1. The time now is 12:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com