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

Discussion in 'Excel Charting' started by, Mar 3, 2008.

  1. Guest


    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?

    , Mar 3, 2008
    1. Advertisements

  2. 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
    Christopher Scott [MSFT], Mar 3, 2008
    1. Advertisements

  3. Jon Peltier Guest

    If you want to keep the original data unchanged, but plot different data,
    then use another range, put in a formula like =100*B2 to convert B2 from a
    percentage to a number, and use this data in your chart. Put it on another
    sheet if your boss would otherwise get confused.

    - Jon
    Jon Peltier, Mar 3, 2008
  4. Guest

    Thanks for looking into this Christopher.

    Jon, it's a brilliant suggestion to use an intermediate table to
    generate the graph. Thanks a million!

    , Mar 3, 2008
  5. Jon Peltier Guest

    Well, I wouldn't say brilliant, but it sure is a lot easier. Worksheet space
    is cheap, and brainpower to force Excel to do what it doesn't want to is

    - Jon
    Jon Peltier, Mar 3, 2008
  6. Guest

    Tina, you are genius! Thanks for this helpful tip!
    , May 11, 2014
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.