Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Increments -- to expand
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 ------------------------------------------------------------------------ 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Increments -- to expand
Thanks, Andy, for the quick and correct reply.
Works great. "Andy Pope" wrote in message ... 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 ------------------------------------------------------------------------ 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 he http://www.spamfighter.com/len |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Expand height of chart? | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |