Combine two type of chart for one series

[Maja]

Hi,

I have the attached data and would like to make clustered chart for 2013, 2014, 2015 i 2016 but for 2017 until 2019 stacked chart next to clustered to compare the actuals and forecast for each category. Stacked chart should have Oranges and Oranges FC and next to them also stacked Apples and Apples FC.

Attached is the sample data.

Thanks for help.

M.

 

[r2c2]

@Maja

I think the clustered + stacked chart approach will genuinely confuse your audience. Not to mention it is very tricky to develop and maintain.

That said, if you just want a quick and easy solution, you can make two charts, one with actual values, another with forecasts and then lay one on top of another to create the impression. See attached.