How do i display this is a graph?

[mdray00]

Hi can anyone help me?

I have this table

tbl Overdue Report Count HistoryOverdue WithJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberNorthern Region211211211211211211211211211211211211TI120120120120120120120120120120120120


I would like to dispay this in a graph which in Excel would be very easy but i cant find how to do it in access?

All i want is the Months along the bottom and i like for each overdue with type. But i cannot for the life of me figure out how to do this as i can only put in 6 fields and access does not seem to understand what i am trying to display.

I put this data into Excel and staright away get the correct result.

Thanks

Mike

 

[mdray00]

I have just seen that the table has not come out corectly.

Overdue With -- Jan -- Feb -- Mar -- etc
Name 1 -- 100 --110 -- 120 --105
Name 2 -- 108 -- 120 -- 108-- 103

 

[pwbrown]

I'm a little confused on what you are after, maybe a screenshot of what you want in excel would help?

 

[mdray00]

 

[mdray00]

I have attached what i am looking to do. Can you help?

Thanks

Mike

 

[pwbrown]

I tried it but it only halfed worked for me, maybe someone else can help you. Access is a pain for charts / graphs. It only wrote the name of three months on the graph although all were included. Also all the points were bunched together and hard to read!