Custom chart to compare quarterly forecasts

[ravikiran]

Hi All,

I have a custom charting requirement. Glad if anyone of can assist me in this. Requirements below:

1. I have yearly data pivoted into Quarterly calculations.
2. Quarterly Forecast and Actual totals.
3. I need to generate a chart which can compare re-forecasts between Forecast/Actual for all quarters as below:
   • Compare Forecast vs Actuals for Q1/Q2/Q3/Q4 for Q1 Forecast
   • Compare Forecast vs Actuals for Q1/Q2/Q3/Q4 for Q2 Re-Forecast
   • Compare Forecast vs Actuals for Q1/Q2/Q3/Q4 for Q3 Re-Forecast
   • Compare Forecast vs Actuals for Q1/Q2/Q3/Q4 for Q4 Actuals
4. I want the Forecast vs Actual for individual quarter to be stacked.

I attached a sample image of expected chart output below:

And I attached an excel file with Sample Data.

Thanks in advance,

Cheers,
Kiran.

 

[Hui]

Hows this?

See attached file:

 

[ravikiran]

Hi Hui,

Thanks for looking into this. Your formatting is much better.

However, isn't there a way to stack the Forecast Vs Actual for every Quarter? That way there will be only 4 Bars for each Quarterly forecast, which should be more usable and readable. Let me know your thoughts?

Thank you,
Ravi.