ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do show value range that doesn't start at zero (https://www.excelbanter.com/charts-charting-excel/53613-how-do-show-value-range-doesnt-start-zero.html)

hoffmanjm

How do show value range that doesn't start at zero
 
All the values fall between 25-40,000. Can I show just 20-40,000 on the
vertical axis, or does it have to start at zero? How do I do it.

David Biddulph

How do show value range that doesn't start at zero
 
"hoffmanjm" wrote in message
...
All the values fall between 25-40,000. Can I show just 20-40,000 on the
vertical axis, or does it have to start at zero? How do I do it.


Format Axis/ Scale
--
David Biddulph



Karen

How do show value range that doesn't start at zero
 
This didn't quite work for me. I had to actually right-click on the
gridline, choose "format grid line", click "scale" and then change the
amounts.

"David Biddulph" wrote:

"hoffmanjm" wrote in message
...
All the values fall between 25-40,000. Can I show just 20-40,000 on the
vertical axis, or does it have to start at zero? How do I do it.


Format Axis/ Scale
--
David Biddulph





All times are GMT +1. The time now is 09:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com