karthikgoel
New Member
Hi I have source data in the below file
Month Actual/ Forecasted Revenue Contract value
Apr-14 Actual 0.02 0.01
Apr-14 Forecasted 0.02 0.022
May-14 Actual 0 0
May-14 Forecasted 0.02 0.04
Jun-14 Actual 0 0
Jun-14 Forecasted 0.03 0.039
I would like to show the bar chart with the Bar representation such that the KPI "Revenue" should have one single bar for each month and portion of that should show how much is actual in different color and how much is forecasted for the same month in different color code on the same bar. Need to do the same with "Contract value" however when I try to generate Bar chart it shows me separate Actual and Forecast bars for each month for the same metric. It would pose interpretation challenges for anybody.
Hope you have understood my problem, Looking forward to your responses
Month Actual/ Forecasted Revenue Contract value
Apr-14 Actual 0.02 0.01
Apr-14 Forecasted 0.02 0.022
May-14 Actual 0 0
May-14 Forecasted 0.02 0.04
Jun-14 Actual 0 0
Jun-14 Forecasted 0.03 0.039
I would like to show the bar chart with the Bar representation such that the KPI "Revenue" should have one single bar for each month and portion of that should show how much is actual in different color and how much is forecasted for the same month in different color code on the same bar. Need to do the same with "Contract value" however when I try to generate Bar chart it shows me separate Actual and Forecast bars for each month for the same metric. It would pose interpretation challenges for anybody.
Hope you have understood my problem, Looking forward to your responses