Thread: Chart Increments -- to expand

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



--------------------------------------------------------------------------------
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 for free now!

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 wrote:
> 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:mraphael@email.uophx.edu>
>
> ------------------------------------------------------------------------
> 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

Thanks, Andy, for the quick and correct reply.

Works great.

"Andy Pope" <andy@andypope.info> wrote in message news:ujQBiUxiGHA.3572@TK2MSFTNGP04.phx.gbl...
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 wrote:
> 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:mraphael@email.uophx.edu>
>
> ------------------------------------------------------------------------
> 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

--
----------------------------------------
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.
Get the free SPAMfighter here: http://www.spamfighter.com/len