Stack bar with two value Columns

[Anonymous]

I am trying to create a stack chart which will have two column, Actual and plan. These two column will have value by each quarter and each Area. I tried using stack char but is is not allowing me to add more than one column. I also tried using Line & Stacked column chart but this is also not working.

I have two table, one for actuals (which has transctions) and other for plan by area & quarter. These wto are linked with one to many relationship
Below is what i am trying to achieve. Your help will be much appreciated

I see some help which suggest using "Dril Down Combo Pro By ZoomCharts". Is this free or do i need to purchase licences for this?

[v-lionel-msft]

Hi @Anonymous ,

"I have two table, one for actuals (which has transctions) and other for plan by area & quarter. "

Which field is used to create the relationship between these two tables? If can please provide sample data.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-lionel-msft key is the combination of Customer+Area+Quarter..

[Anonymous]

@v-lionel-msft I can bing the actuals to master table (which has plan). Only issue i see is how to plot two value in same chart.