Can I display the actual data in the data field of a pivot chart?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Excel 2003, I am creating a pivot table using customer data similar to
the following:

Customer Location Interface Code
11 Word 123
12 Excel
13 Outlook 456
21 Word
22 Excel ABC
23 Outlook XYZ

I am placing the Customer Location in the row area, the Interface in the
column area and the Code in the data area. I would like the Code to show in
the pivot table as the "123", "456", "ABC", and "XYZ". I don't want a count
of those values, I just want the actual values to print in the pivot table.
Is this possible?

Thanks for any help!
Tom
 
PivotTables are designed to aggregate data so the data area can only contain
some kind of summation (or count, or standard devitation, etc.)

ERR229
 

Ask a Question

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. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top