PC Review


Reply
Thread Tools Rate Thread

Chart values default to 0 on the bottom

 
 
Bill
Guest
Posts: n/a
 
      8th Jul 2003
I am creating a chart that will plot a series of numbers
that are relatively close to one another, say 5 numbers
that range from 6 to 7.1. When I chart it, the graph is
rather smushed (flat) looking because the chart insists on
having to start with 0 at the bottom. If I could have the
chart start at say 5, then the graph would have some more
up and down motion to it. Anyway to specify the axis
values of a chart? Thanks
 
Reply With Quote
 
 
 
 
Debra Dalgleish
Guest
Posts: n/a
 
      8th Jul 2003
To change the axis scale:

1. Double-click on the axis
2. In the Format Axis dialog box, select the Scale tab
3. Set a Minimum and/or Maximum
4. Click OK

Bill wrote:
> I am creating a chart that will plot a series of numbers
> that are relatively close to one another, say 5 numbers
> that range from 6 to 7.1. When I chart it, the graph is
> rather smushed (flat) looking because the chart insists on
> having to start with 0 at the bottom. If I could have the
> chart start at say 5, then the graph would have some more
> up and down motion to it. Anyway to specify the axis
> values of a chart? Thanks



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Positioning x axis at bottom of chart with negative values Debs1967 Microsoft Excel Charting 5 25th Feb 2010 04:13 PM
Is there a way to draw a vertical line from a point on the chart line to the bottom of the chart greg Microsoft Excel Programming 7 15th Jul 2009 06:10 PM
Getting x axis values on bottom in a logarithmic scale chart =?Utf-8?B?U3RldmVu?= Microsoft Excel Misc 2 12th Jun 2007 07:46 PM
Cutting off the bottom of a chart? Lew Bryson Microsoft Excel Charting 2 21st Jul 2006 03:21 PM
Top 20 and bottom 20 values Brian Camire Microsoft Access Queries 9 8th Jan 2005 02:36 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:37 PM.