Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
hoffmanjm
 
Posts: n/a
Default 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.
  #2   Report Post  
David Biddulph
 
Posts: n/a
Default 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


  #3   Report Post  
Karen
 
Posts: n/a
Default 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



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 create a schedule from a list of dates ? Gavin Morris Charts and Charting in Excel 2 October 28th 10 04:08 PM
Array to named range conversion... i-Zapp Excel Discussion (Misc queries) 4 October 25th 05 09:09 PM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
UDF and Calculation tree Ken Wright Links and Linking in Excel 1 February 6th 05 04:58 PM
Lookup with search range start based on position of last blank lin rcmodelr Excel Worksheet Functions 0 November 14th 04 06:32 AM


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