Chart Increments -- to expand

[Michael Raphael]

I'm trying to chart a bar graph to show the average responses of some survey data of two groups.

The bar values are 4.2 and 3.8

When I create the bar graph, the lowest value on the Y axis shows 3.5.

How do I make the Y axis start at 0 to portray the entire scale?

Thanks for the advice.

Mike Raphael

 

[Andy Pope]

Hi,

Double click the y axis and on the scale tab of the format dialog
uncheck the Auto scale Minimum value and enter the value of zero.

Cheers
Andy

 

[Michael Raphael]

Thanks, Andy, for the quick and correct reply.

Works great.

Hi,

Double click the y axis and on the scale tab of the format dialog
uncheck the Auto scale Minimum value and enter the value of zero.

Cheers
Andy

I'm trying to chart a bar graph to show the average responses of some
survey data of two groups.

The bar values are 4.2 and 3.8

When I create the bar graph, the lowest value on the Y axis shows 3.5.

How do I make the Y axis start at 0 to portray the entire scale?

Thanks for the advice.

Mike Raphael
<mailto:[email protected]>

------------------------------------------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 532 spam emails to date.
Paying users do not have this message in their emails.
Try SPAMfighter <http://www.spamfighter.com/go.asp?t=249> for free now!

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

--