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

Discussion in 'Excel Charting' started by aonnime@gmail.com, Mar 3, 2008.

  1. Guest

    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
     
    , Mar 3, 2008
    #1
    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
    agree.

    --
    Thanks,
    Christopher

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


    "" 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
    >
     
    Christopher Scott [MSFT], Mar 3, 2008
    #2
    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, Microsoft Excel MVP
    Tutorials and Custom Solutions
    Peltier Technical Services, Inc. - http://PeltierTech.com
    _______


    <> wrote in message
    news:...
    > 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
     
    Jon Peltier, Mar 3, 2008
    #3
  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!

    Anne
     
    , Mar 3, 2008
    #4
  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
    expensive.

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Tutorials and Custom Solutions
    Peltier Technical Services, Inc. - http://PeltierTech.com
    _______


    <> wrote in message
    news:...
    > Thanks for looking into this Christopher.
    >
    > Jon, it's a brilliant suggestion to use an intermediate table to
    > generate the graph. Thanks a million!
    >
    > Anne
    >
    >
     
    Jon Peltier, Mar 3, 2008
    #5
  6. Guest

    On Monday, March 3, 2008 4:17:02 AM UTC, 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


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

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.
Similar Threads
  1. Eva Whitley
    Replies:
    2
    Views:
    149
    Eva Whitley
    Apr 29, 2004
  2. TryingToExcel
    Replies:
    1
    Views:
    197
    Tushar Mehta
    Feb 18, 2005
  3. vp23larry
    Replies:
    2
    Views:
    316
    Collins32
    Jun 23, 2005
  4. Aaron
    Replies:
    1
    Views:
    267
    Del Cotter
    Aug 17, 2007
  5. -markc
    Replies:
    2
    Views:
    218
    -markc
    Oct 31, 2007
  6. DeniseD1128
    Replies:
    1
    Views:
    142
    Jon Peltier
    May 13, 2009
  7. darrel
    Replies:
    1
    Views:
    325
    Tobi Ackerman
    Jan 22, 2011
  8. Tonso
    Replies:
    1
    Views:
    442
Loading...