Add Second Series to Graph

[Dave]

Hi All,

I am really struggling and need some help please.

I want to produce a Stacked Column Chart in Access 2007.

I have 4 bits of data:

Count KO/G
Count KO/A
Count KO/R
Number of Actual KO

I want the first column to be stacked: Count KO/G + Count KO/A + Count KO/R

and the second column to be: Number of Actual KO

I have managed to stack Count KO/G + Count KO/A + Count KO/R in a single
stacked column chart but cannot add the second one.

The first one looks like this:

SELECT Null AS Expr1, RAG_KO.[Count KO/G], RAG_KO.[Count KO/A],
RAG_KO.[Count KO/R]
FROM RAG_KO;



Any assistance much appreciated.

Thanks