A dynamic combination of Column Chart and Line Chart
Learn Dynamic Variance Arrow Chart step by step
In this dynamic chart you will learn how to hide a series by unchecked a checkbox.
![Dynamic Chart](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/DynamicChartWithCheckboxes/Dynamic-Chart-11.jpg)
Below is the data point for which we will create this chart.
![Data for Chart](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/DynamicChartWithCheckboxes/Dynamic-Chart-1.jpg)
Below are the steps to create this dynamic chart:
- Copy “A1:A11” and paste on “G1”
- Copy header “B1:D1” and paste on “H1”
- Go to Chart Sheet.
- Go to the Developer tab > Insert >Form Controls >Check Box
![Insert form control Check box](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/DynamicChartWithCheckboxes/Dynamic-Chart-3.jpg)
- Insert 3 Check boxes and rename them as Call Offered, Call Answered, Abandoned
- Right click on check boxes and click on “Format Control…”
![Format Control option](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/DynamicChartWithCheckboxes/Dynamic-Chart-4.jpg)
- Put in cell link of Call offered Checkbox “Data!$F$1”
- Put in cell link of Call Answered Checkbox “Data!$F$2”
- Put in cell link of Abandoned Checkbox “Data!$F$3”
![Format Control Window](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/DynamicChartWithCheckboxes/Dynamic-Chart-5.jpg)
- Now go to Data sheet and put formula on
- Range H2 “=IF($F$1,B2,NA())”
- Range I2 “=IF($F$2,C2,NA())”
- Range J2 “=IF($F$3,D2,NA())”
![Put Formula](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/DynamicChartWithCheckboxes/Dynamic-Chart-6.jpg)
- Fill down the formula on “H2:J11”
- Change the number format of column J as percentage.
- Select Range “G1:J11”
- Go to Insert>>Charts>>2D Column>>Clustered Column
![Insert Chart](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/DynamicChartWithCheckboxes/Dynamic-Chart-7.jpg)
- Now right click on any column and click on “Change Chart Type”
![Change Chart Type option](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/DynamicChartWithCheckboxes/Dynamic-Chart-8.jpg)
- In Change Chart Type window change the chart type for Abandoned as “Line with Markers”
- Also check the Secondary Axis box
![Change Chart Type window](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/DynamicChartWithCheckboxes/Dynamic-Chart-9.jpg)
- We will change the Chart Style now
- Select the chart and go to “Design Tab>>Chart Style>>Style6”
![Chart Style](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/DynamicChartWithCheckboxes/Dynamic-Chart-10.jpg)
- Change the chart title as “Date wise Performance”
- Cut (Ctrl+X) the chart and paste on Chart Sheet.
- Insert a rectangle in Chart Sheet from Insert>>Shapes>>Rectangles>>Rectangle
- Match the Rectangle width with chart width and send to back of check boxes.
Our dynamic Chart is ready. Please download this excel file for practice.
![Dynamic Chart](https://www.pk-anexcelexpert.com/wp-content/uploads/AdvancedChartandInfo-graphics/DynamicChartWithCheckboxes/Dynamic-Chart-11.jpg)