Hi,
I have been trying to solve a problem for some time, but unsuccessfully.
I am trying to output a graph with two lines one for "Results by Month" and one line for "Target Per Month". The idea is you could see how someone is performing against target by month throughout the year.
ie: Results Crosstab Looks Like:
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Etc
2005 | 100 | 212 | 150 | 117 | 255 | 157 | 214 | 452 | 111 | 189 | Etc
I can create the graphs OK from within Access using a crosstab query and output a graph showing the "Results by Month" line, no problem.
However I am unable to integrate into the crosstab the target figures by month so the graph displays two lines.
How would I do this?
Thanks
Daz....
I have been trying to solve a problem for some time, but unsuccessfully.
I am trying to output a graph with two lines one for "Results by Month" and one line for "Target Per Month". The idea is you could see how someone is performing against target by month throughout the year.
ie: Results Crosstab Looks Like:
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Etc
2005 | 100 | 212 | 150 | 117 | 255 | 157 | 214 | 452 | 111 | 189 | Etc
I can create the graphs OK from within Access using a crosstab query and output a graph showing the "Results by Month" line, no problem.
However I am unable to integrate into the crosstab the target figures by month so the graph displays two lines.
How would I do this?
Thanks
Daz....
Last edited:
