From: StuJol on
Using Access 2003 i have a table

Date Result Text
1/1/2010 1.12 Good
1/2/2010 1.54 Good
1/3/2010 3.21 Bad
1/4/2010 4.11 Very Bad

i can create a pivot chart to show the results by months. What i want to do
is at each results datapoint i would like to display the text from the text
colume. so instead of the pivotchart displaying numbers i want it to display
text and numbers. when i try this the text field is created as a count of
text which gives me 1 for each month...
does anyone know how to remove the count function and display text