View Single Post
  #1  
Old May 17th, 2010, 11:19 AM posted to microsoft.public.access.forms
StuJol
external usenet poster
 
Posts: 122
Default Displaying Text Data in Pivot Chart

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