From what I see it is all going to tie back to the data that's in the
table you are working from. If it is stored there as a Percentage
format, the raw data will say .15 but will display as 15%.

Your chart axis will default to the same format, 15%. When you change
the axis number style to general it will change it to the data's raw
form .15

If it were me, I would store the data as a raw general format = 15, not
a percentage format =.15 result as 15%. Then on your table column
heading just denote "Percentage" or (%).

If you really need the % signs all the way down the side of those
numbers, insert a tiny column and just paste % all the way down the
side. My people never look at the data tables anyways.

I hope this makes sense.

balmalik wrote:
I have an xy scatter plot with the x-axis numbers as percentage. How can
I remove the percentage sign next to each number in the x-axis since the
sign is already defined in the axis title?

I tried to change the format of the number, I selected general and
multiplied the coulmn by 100 but it did not work.... Can you please
help???!

Thanks in advance....


--
balmalik
------------------------------------------------------------------------
balmalik's Profile: http://www.excelforum.com/member.php...o&userid=36517
View this thread: http://www.excelforum.com/showthread...hreadid=563312