Chart Increments -- to expand

  • Thread starter Thread starter Michael Raphael
  • Start date Start date
M

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
 
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
 
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

Michael said:
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!
Click to expand...

--

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

--
 
Back
Top