Cutting off the bottom of a chart?

[Lew Bryson]

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,

 

[Tushar Mehta]

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.

--
Regards,

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

 

[Lew Bryson]

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.

MUCH better. Thanks!