Creating charts

[iamnamja]

Hi,

I'm trying to create a chart in access... I keep running into an issue because I believe the data (query) is not in the right format. Any idea how to go about this?

I have a data set as follows:
Report Date Index Value
7/1/2011 A 10


7/2/2011 A 11
7/3/2011 A 15
7/4/2011 A 20
7/5/2011 A 8
7/1/2011 B 21
7/2/2011 B 29
7/3/2011 B 24
7/4/2011 B 19
7/5/2011 B 25

I would like to graph index A and B and show the change in the value through the dates: 7/1/2011 to 7/5/2011

but it looks like access is not recognizing this as what I want... I think if I change the format of the query (which I would need help on if this is the only way) so that the dates are the headers and values are located across as such:

Index 7/1/2011 7/2/2011 7/3/2011 7/4/2011 7/5/2011
A 10 11 15 20 8
B 21 29 24 19 25

Any suggestions will be greatly appreciated! Thanks!

[iamnamja]

Sorry guys....

I figured this one out by myself. I'm just sooo used to clicking on "view" to get the report that I want... But realized for access 2007, I need to click on print preview to get the data!