+ Reply to Thread
Results 1 to 2 of 2

Pivot Table formatting question

  1. #1
    Registered User
    Join Date
    02-22-2010
    Location
    Des Moines, IA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Pivot Table formatting question

    I want to be able to create a pivot table that counts the number of entries that have a value in between two percentages from a long list (for example, I might want the pivot table to show 0%-1%, 1%-2% and 3%-4% and the pivot table would count how many from the list qualify. I am using the "group" pivot table option to do this). The problem is that the format of the numbers shows up as 0-.01, .01-.02, .03-.04 and every formatting change I have tried has not allowed me to change these numbers to percentages. I would just put the range as a percentage in a column next to the pivot table, but I want this formatting to show up correctly in the pivot table chart as well.
    Is there any easy way to get this to format correctly?

    Thanks

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Pivot Table formatting question

    I don't think this can be changed because by grouping Excel must convert the numeric values into a text string. You might try copying the values to an adjacent column and using those cells in the chart.
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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