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

On Sunday, March 2, 2008 at 11:17:02 PM UTC-5, 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?


I found a different way about it...

I have a data column with the percentage numbers which is formatted as

0;; which means: no decimals;no negatives;0 doesn't show

also, no percent sign...
this way I have a clean column of numbers which I could also use as whole numbers if need be.

My solution came in the formula which I use based on that data...
supposing the data column is B, my formula would be:

(A1 * B1%) / C1