How do you create this chart in Excel?
In this video you’ll learn how to add series lines to stacked column charts.
Instead of series lines, you might want to add a shaded background to each of the stacked sets.
We can do that using stacked area chart and combine it with our stacked column chart in Excel.
Watch the steps in this video:
Feel free to Download the Workbook HERE.
Hello Leila,
I watch your tutorials and I want to thank you for the excellent material you provide to us.
I have a question, too. I have in the same combo chart a few series with the stacked column chart type and a few series with the line chart type. The stacked columns stay always in the background, no matter how I order the legend entries in the select data source. Do you know how can I set the line charts in the background?
Thank you.
Kind regards,
Daniel Sarba
Hi Daniel, best would be to post your specific question with screenshots on an Excel forum – for example Microsoft’s Tech Community right here. With over 25K members and almost 30K posts, your solution is either ready and waiting or has the possibility of being answered more quickly than we may be able. I’m certain someone there can inform you of the best way to reach your solution.