Cutting off the bottom of a chart?

  • Thread starter Thread starter Lew Bryson
  • Start date Start date
L

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,
 
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,
Click to expand...
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
 
Tushar Mehta said:
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.
Click to expand...

MUCH better. Thanks!
 
Back
Top