+ Reply to Thread
Results 1 to 2 of 2

Pivot Chart displaying percentage values as decimal values

  1. #1
    Registered User
    Join Date
    04-09-2013
    Location
    Costa Rica
    MS-Off Ver
    Excel 2010
    Posts
    59

    Thumbs up Pivot Chart displaying percentage values as decimal values

    Hello people:

    Not sure why but Excel 2010 is displaying a column with percentage values with decimal values on a Pivot Chart. Example It shows 0.7823232 instead of 78% as shown on main Excel Column.

    Already tried formatting Pivot Table's Row labels to percentages and refreshed data but no success!

    Would appreciate any help!

    Thanks!
    Last edited by figo12; 11-05-2013 at 03:07 PM.

  2. #2
    Registered User
    Join Date
    04-09-2013
    Location
    Costa Rica
    MS-Off Ver
    Excel 2010
    Posts
    59

    Re: Pivot Chart displaying percentage values as decimal values

    Just solved it, it looks to be an Excel bug, if there are hidden rows and or empty rows on main table/columns, Excel will not show percentages on pivot chart, found out issue when copied original table/columns to another sheet.

    Just an FYI if it happens for someone else.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 10-01-2012, 10:00 PM
  2. Displaying actual values on a percentage bar graph
    By BFlick11 in forum Excel General
    Replies: 9
    Last Post: 07-21-2011, 08:39 AM
  3. Displaying larger values with smaller values in a Column Chart
    By Max9 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-20-2010, 11:59 PM
  4. Displaying Zero Values in a Chart
    By ajames in forum Excel General
    Replies: 1
    Last Post: 04-12-2006, 12:53 PM
  5. [SOLVED] Displaying XValues and Values for chart using VBA
    By Barb Reinhardt in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-12-2006, 09:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1