How do I change the format of group by data in Excel 2003 pivot tables
- by Bernard
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
Also I have a column in the pivot table that says Total which is the Count of the number of contracts in that range, i.e.
Value Total
0 - 10 1
11 - 20 1
Its an autogenerated column heading that Excel put in. How do I change this to say Number of contracts. I want it changed because when I chart the pivot table, the series is called called Total :(
