Dynamic Combination Chart in BI publisher

Hello All,

I am having a below requirement in charts and looking for the solution in BI charts.

My requirement as follows:

We need to create only one query with lots of fields (like emplid, emplrcd, country, compensation, dept and etc). But I want to create only one chart and dynamically I need to pass the values (x- axis and y-axis) (eg: I may want to create a chart with a combination of "dept and emplid") and another combination would be "country and compensation") and etc..

My question here is: How can I pass the x-axis and y-axis values dynamically? Appreciate your help on this.