Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Two Values on X Axis

Status
Not open for further replies.

TaylorTot

Technical User
Dec 23, 2003
96
US
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top