So I was able to solve my problem by creating a table joined to the original table that housed the ID of all projects, a generic RAGStatus to house Red, Amber, Green values and a RAGType field. I loaded each field to the table using concatenation and changing RAGType based on the type of RAG I was loading. Then I used the RAGType field as my x-axis dimension. Hopefully that helps anyone else who may run across this problem. Appreciate anyone who may have looked into this.