How to Make a Clustered Stacked and Multiple Unstacked Chart in Excel 2019

preview_player
Показать описание

Quickly learn how to make a new chart type in Excel. This is not currently an option, but with this tip, you can make the combo chart you want.

If you want to see the Excel 2010 version, check this Article out:
Рекомендации по теме
Комментарии
Автор

I was trying to do this and format the data as a table so that added information would automatically populate in the clustered stack column chart. But, I wanted the horizontal axis to have two levels such as budget vs. actual grouped by different projects. When I format the data as a table, it no longer automatically makes the horizontal axis labels multi level and I need to do some clean up removing "column 1" and column 2" labels and data.
Is it possible to format as a table and add extra horizontal axis level of information manually?

tiffanylake