Create a Column Chart in Access

[j2curtis64]

Hello,

I hope I am in the right area to ask this question. I am trying to create a chart in Access but havent done it before, so I need some assistance.

1). I have the following data:

Code	CountOfType	Month
Q	3	3/1/2012
K	1	2/1/2012
CDSA	1	2/1/2012
C	3	2/1/2012
W	1	12/1/2011
W	2	11/1/2011
CDSA	1	11/1/2011
W	2	10/1/2011
G	2	10/1/2011
C	1	10/1/2011

2). I dont to create a chart where I am showing the transaction count (countoftype) in the Y axis and the code and bill_date in the Y. I want the chart to show the transaction by code and show what month it occurred. Would this be a crosstab query?

Thanks

[June7]

Try this as the RowSource sql for the graph:

TRANSFORM First(Table1.CountOfType) AS Type SELECT Table1.Month FROM Table1 GROUP BY Table1.Month PIVOT Table1.Code;