create pie chart in excel from checkbook table

From the menu select Change Series Chart Type. This will change the chart type from a bar chart to a line chart. Click on any data bar for 2011 (this will select all the data bars for 2011) and right click.This will insert a column chart with three column bars for each Quarter. With both the checkboxes checked, select the entire data and go to Insert –> Charts–> Column–> Clustered Column.This formula returns the value from original data if the check box for that year is checked, and #N/A if it is unchecked.Delete the data for 20, and use the following formula:.

Copy the original chart data from B2:F5 and paste it in some other location.Repeat Steps 2 to 4 to insert another check box for 2012, and use a different cell link (I have used C8 here).Cell C7 would return TRUE when the check box is checked, and FALSE when unchecked.

Right click on the check box and select Format Control, specify a cell link (in this case I have used C7).Change the name of the Checkbox from Check Box 1 to 2011. Click anywhere in the worksheet to insert the check box.Go to Developer tab –> Insert –> Form Controls –> Check Box (Form Control).Dynamic Excel Chart with Series Selection Check-box Dynamic excel chart can give you something as shown below:Ī single click instantly shows you the performance of 2013 as compared to 2011 or 2012. At the same time, you also want to compare the growth with previous years.

Suppose you have the financial data for a company ABC Ltd, and you want to see how the revenue has grown over the quarters. Apart from being super cool, Excel dynamic charts are really helpful in presenting a comparative analysis from the data.

Create pie chart in excel from checkbook table