Cutting off the bottom of a chart?
 

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,

--
Lew Bryson


www.LewBryson.com

Cutting off the bottom of a chart?
 

In article ,
says...
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

Cutting off the bottom of a chart?
 

"Tushar Mehta" wrote in message
In article ,
says...
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.

MUCH better. Thanks!

--
Lew Bryson


www.LewBryson.com