Chart help

L

lmossolle

I would like to create a 2 line chart, I can get one line to appear, with the
following;

I am trying to add a second line on a graph, the name is [AMR Query].actdays1
thru [AMR Query].actdays10


SELECT Null AS Expr1,
[AMR Query].projaccdays1 AS 1,
[AMR Query].projaccdays2 AS 2,
[AMR Query].projaccdays3 AS 3,
[AMR Query].projaccdays4 AS 4,
[AMR Query].projaccdays5 AS 5,
[AMR Query].projaccdays6 AS 6,
[AMR Query].projaccdays7 AS 7,
[AMR Query].projaccdays8 AS 8,
[AMR Query].projaccdays9 AS 9,
[AMR Query].projaccdays10 AS 10
FROM [AMR Query];

I am trying to add a second line on a graph, the name is [AMR Query].actdays1
thru [AMR Query].actdays10

Please assist!

Thanks!!!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Help 1
Graph HELP PLEASE 0
Report Help 1
Gaps in ordered series 1
Counting occurrances in a chart 4
Pivot Chart with several series fields 0
Cascade queries 7
Query on Two Tables 11

Top