If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|