Create line chart in ms access 2007

[bubu77]

Hi,

I need to display the out put of a table as chart in ms access 2007. My table is as below.

ItemID	Week 1 Value	Week 2 Value
1001	87	5
1002	80	1
1003	42	1
1004	55	164

In the chart X co ordinate should be the "ItemID" and the Y co ordinate should be the week number (eg, week1, week2 ...etc).
Is it possible to display the chart with the above table? Or do I need to transform the table and then dosplay as chart?

Also can I transform the above table as shown below using a single Transform query ?

ItemID	Week	Value
1001	1	87
1001	2	5
1002	1	80
1002	2	1
1003	1	42
1003	2	1
1004	1	55
1004	2	1664

Also please let me know if I can transform the table as above is it possible to create the chart.



Please help me resolving these.

[June7]

The original data should be chartable. Each week field should result in a graph line. The RowSource for the graph would be like:

SELECT ItemID, [Week 1 Value], [Week 2 Value] FROM tablename;