Value Axis - How to remove percent sign without changing values?
On Sunday, March 2, 2008 at 11:17:02 PM UTC-5, wrote:
Hi,
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?
Thanks
Anne
I found a different way about it...
I have a data column with the percentage number which is formatted as 0;; which means no decimals;no negatives;0 doesn't show... 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, the formula would be:
(A1 * B1%) / C1
Cheers!!
|