1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL.CH

  • Value Axis - How to remove percent sign without changing values?

    From d.andrewslima@gmail.com@21:1/5 to aon...@gmail.com on Tue Apr 3 12:33:51 2018
    On Monday, March 3, 2008 at 1:17:02 AM UTC-3, aon...@gmail.com 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

    Heh, 10 years lated and I had the same doubt,lol.

    Got my answer with "cell"*100. It was really simple and I feel kind of stupid, but surely thankful.

    Thanks everyone!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From dutchbuttonworks@gmail.com@21:1/5 to All on Fri Jun 22 01:04:25 2018
    Thanks a lot!!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From brankostanic0@gmail.com@21:1/5 to dutchbut...@gmail.com on Wed Jun 27 07:04:56 2018
    On Friday, June 22, 2018 at 10:04:27 AM UTC+2, dutchbut...@gmail.com wrote:
    Thanks a lot!!

    Right click on the vertical axis-> change chart type -> and instead of 100% stacked column select stacked column. That is it

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From maifeibu@gmail.com@21:1/5 to aon...@gmail.com on Wed Jul 25 12:29:47 2018
    On Sunday, March 2, 2008 at 11:17:02 PM UTC-5, aon...@gmail.com 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 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

    Cheers!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From maifeibu@gmail.com@21:1/5 to aon...@gmail.com on Wed Jul 25 12:26:09 2018
    On Sunday, March 2, 2008 at 11:17:02 PM UTC-5, aon...@gmail.com 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!!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)