Search This Blog

Thursday, June 4, 2020

Dynamic Combo Chart in Excel

A combination chart is a chart type that has more than one type of chart in a single view. Most times it's a combination of a column and line chart where it would plot something like volume and revenue together. The volume data can be a column chart and the revenue data can be the line chart. Excel has provided this combo chart capability for quite a while but in later version it became very easy as a chart type selection (which this video will cover). However there not really an option to give interaction like selecting to view the column chart alone and then both chart type together with a click of the button. This video will cover a quick hack on how to create a dynamic or interactive combo chart using slicers.

No comments:

Post a Comment