View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Christopher Scott [MSFT] Christopher Scott [MSFT] is offline
external usenet poster
Posts: 27
Default Value Axis - How to remove percent sign without changing values?

I played around for a while, but could not find a format code to make 80%
display as 80. I could not get this to work on the sheet cells format
either. You could right click the value axis, choose Format, choose Number
and type in the format code .00 to make 80% display as .80 but it sounds like
you don't want that.

Do you really need to get rid of the percentage sign? I think it would make
the chart more readable and easier to interpret if it were there. Tufte would


This posting is provided "AS IS" with no warranties, and confers no rights.

" wrote:


I would like to keep the percentage values but remove the percent sign
from the value axis of a 100% stacked bar chart. Can it be done?