Hi,

I have a Access db that uses Access Graphs in the reports.

The reports work fine and creates the graphs with no problem from within access.

I have now had a request to display another line in the graphs.

Line 1: Performance (Line already showing)
Line 2: Target (I need to add a new line for this)

I have created a new tbl to store the targets (for 40 sites).

How do I get the crosstab query to return both the performance data and target data and use them on the same graph?

IE:
Target 40% (Same for each month of the year)
Actual: 42% (Varies month by month depending on data)

Any help will be appreciated.

Daz...