CR9 Stacked Bar Chart Question

[humanageek]

Everyone,

I have several stacked bar charts to develop, and for the life of me, I can't figure out how to get all the information to display right.

The chart is for "open issues," and I have to display multiple teams in the stack, and this is for each week, going back 10 weeks. Here's my SQL:

SELECT COUNT(CL_CALL_LOGGING.CALL_NUMBER), AR_CLIENT_COMPANY.CLIENT_CO_NAME
FROM
CL_CALL_LOGGING, AR_CLIENT_COMPANY
WHERE
CL_CALL_LOGGING.OPEN_FLAG = 1 AND
CL_CALL_LOGGING.RESOLVED = 0 AND
CL_CALL_LOGGING.PARTITION = 6 AND
CL_CALL_LOGGING.CLIENT_COMPANY_REF = AR_CLIENT_COMPANY.CLIENT_CO_REF AND
AR_CLIENT_COMPANY.CLIENT_CO_NAME IS NOT NULL AND
CL_CALL_LOGGING.TIMEDATE_CALL_LOG > SYSDATE - 8
GROUP BY AR_CLIENT_COMPANY.CLIENT_CO_NAME
ORDER BY 1

Obviously this is for the current week. I've created a query for each of the 10 weeks, but it doesn't seem like the most efficient way to do it (because it doesn't work. lol)

Any help you can provide would be GREATLY appreciated.

Kyle