Hi all

I have an excel column chart that goes up to 100% on one column (all results
go from 0-100%) but the chart auto puts the chart axis up to 120% - Is it
possible to set it to just a 100%?

any help appreciated

Rexmann

PS i'm running excel XP

Double-click on the Value Axis
On the Scale tab, change the Maximum to 1
Click OK

rexmann wrote:
Hi all

I have an excel column chart that goes up to 100% on one column (all results
go from 0-100%) but the chart auto puts the chart axis up to 120% - Is it
possible to set it to just a 100%?

any help appreciated

Rexmann

PS i'm running excel XP


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hi Debra

Thanks, worked a treat. Should have guessed really -

thanks again

cheers Rexmann

"Debra Dalgleish" wrote:

Double-click on the Value Axis
On the Scale tab, change the Maximum to 1
Click OK

rexmann wrote:
Hi all

I have an excel column chart that goes up to 100% on one column (all results
go from 0-100%) but the chart auto puts the chart axis up to 120% - Is it
possible to set it to just a 100%?

any help appreciated

Rexmann

PS i'm running excel XP


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html