Home » Questions » Computers [ Ask a new question ]

How do I change the format of group by data in Excel 2003 pivot tables

How do I change the format of group by data in Excel 2003 pivot tables

"I have a data that lists the value of a contract per contract number.
So I've created a pivot table that counts the number of contracts valued at 0 - 10, 11 - 20, etc.
I want to be able to format the group, e.g. $0 - $10, $11 - $20
I've tried formatting the underlying data as currency and formatting the column in the pivot table, but it still shows as 0 - 10, 11 - 20"

Asked by: Guest | Views: 124
Total answers/comments: 1
Guest [Entry]

"It's not a terribly satisfying solution, especially if you have many groups, but you can change the names of the groups by typing over them individually in the formula bar at the top of the sheet. Thankfully, unlike formatting, it remembers the changed names even if you mess around with the contents and layout of the PivotTable. (Of course, if you change the grouping options themselves, your customizations will be lost.)

As far as the ""Total"" label, it won't let you change that on the PivotTable (not even via the formula bar), but it will let you change the title of the chart - just select the title and type in your desired text. Again, unlike most formatting changes, it will remember your new title even if you play around with the chart options."