% in Charts

A

Aardvark

Dear all,

I have a chart based on data expressed as percentages. I have successfully
changed the scale to represent % but would like it to show just figures eg
10, 20, 30 not 10%, 20% 30%. I would also like to increase the length of
the axis. Any ideas?

Thanks
 
E

Earl Kiosterud

Aardvark,

Click any label on the axis (which selects the axis), Right-click, Format
Axis. Choose Number, and change the number format to something non-%.

As for increasing the length of the axis, I'm not sure what you mean. You
can "stretch" the plot area, physically lengthening the axis. Or maybe you
want to change the range of values. If the latter, do the same as above,
selecting "Scale" and change the min and max axis values.
 
A

Aardvark

Thanks Earl,

I can do that but then the scale turns from 10, 20, 30 to 0.1, 0.2, 0.3
which I don't want either. If I change the scale to max 100 none of the
data appears because the highest value will be 1 (100%), insignificant on a
0-100 scale.

Danny
 
E

Earl Kiosterud

Aardvark,

I see now. Help says that the % sign in the format code multiplies the
value by 100 AND supplies the % symbol. I think you may have to actually
plot values that are 100 times the originals to do this using an extra
column.
 
A

Aardvark

Cunning! Thanks Earl

Earl Kiosterud said:
Aardvark,

I see now. Help says that the % sign in the format code multiplies the
value by 100 AND supplies the % symbol. I think you may have to actually
plot values that are 100 times the originals to do this using an extra
column.
Click to expand...
 
Top