Hello,

I have the following select statement:

SELECT InspectionGraph_GetData_SelQry.month,
InspectionGraph_GetData_SelQry.[Inpsection Type],
Sum(InspectionGraph_GetData_SelQry.[0-10 Days]) AS [SumOf0-10 Days],
Sum(InspectionGraph_GetData_SelQry.[11 - 15 Days]) AS [SumOf11 - 15
Days], Sum(InspectionGraph_GetData_SelQry.[16-20 Days]) AS [SumOf16-20
Days], Sum(InspectionGraph_GetData_SelQry.[21-30 Days]) AS [SumOf21-30
Days], Sum(InspectionGraph_GetData_SelQry.[Over 30 Days]) AS [SumOfOver
30 Days]
FROM InspectionGraph_GetData_SelQry
GROUP BY InspectionGraph_GetData_SelQry.month,
InspectionGraph_GetData_SelQry.[Inpsection Type];

What I want to do is have it chart a stacked bar chart. Unfortunately
I have two values that I would like in the x axis: Month and
Inspection Type.

Can anyone tell me how I can chart two values on the x axis?

Thank you for your help!

Taylor wrote:

What I want to do is have it chart a stacked bar chart. Unfortunately
I have two values that I would like in the x axis: Month and
Inspection Type.
>
Can anyone tell me how I can chart two values on the x axis?

Use a series.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me

I am not sure what you mean by use a series? Can you provide
additional information?

Thanks for your help!

Tim Marshall wrote:

Taylor wrote:
>

>
Use a series.
>
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me