Stacked Column Chart (Access 2007)

dvent · #1 07-27-2009, 08:23 AM

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
dvent

dvent · #2 07-28-2009, 08:01 AM

FYI All. I have posted this question also on MS Discussions but have yet had no response

Welcome to the Excel Forum

Forum Statistics