Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / July 2006

Tip: Looking for answers? Try searching our database.

Cutting off the bottom of a chart?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lew Bryson - 21 Jul 2006 13:41 GMT
I'm charting my weight loss, and I'd like to see more detail. My x-axis is
weeks, my y-axis is my weight. I'm never going to get below 150 -- How do I
get the chart to just show the y-axis between, say, 150 and 350?

Thanks in advance,

Signature

Lew Bryson

Lew@LewBryson.com
www.LewBryson.com

Tushar Mehta - 21 Jul 2006 13:53 GMT
> I'm charting my weight loss, and I'd like to see more detail. My x-axis is
> weeks, my y-axis is my weight. I'm never going to get below 150 -- How do I
> get the chart to just show the y-axis between, say, 150 and 350?
>
> Thanks in advance,

Double-click the y-axis, then click the Scale tab.  In there, set the
Minimum value to 150 and ensure that the corresponding 'Auto' checkbox is
*not* checked.

Signature

Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

Lew Bryson - 21 Jul 2006 14:21 GMT
"Tushar Mehta" <tmUnderscore200310@tushar-mehta.SeeOhEm> wrote in message
>> I'm charting my weight loss, and I'd like to see more detail. My x-axis
>> is
[quoted text clipped - 7 lines]
> Minimum value to 150 and ensure that the corresponding 'Auto' checkbox is
> *not* checked.

MUCH better. Thanks!

Signature

Lew Bryson

Lew@LewBryson.com
www.LewBryson.com

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.