A pie chart in Excel is a circular graphical representation that shows how individual parts contribute to a whole. Pie charts are generally categorized into static and dynamic. A dynamic pie chart automatically updates when the underlying data changes, making it ideal for tracking evolving datasets.
Creating a dynamic pie chart using offset formula
We can create a dynamic pie chart using the offset formula. So to this follow the following steps:
Step 1: Create a table and insert values in it. Apply the offset formula to get the value of the total column. Here 2000 value is present in the B4 cell. So, to get the first value of the total column, we will have to look for the value in the 0th row and 3rd column from the point of reference. The total column is calculated from the sum of Sale and Tax, so whenever there is any change in the values of the table, the Total column automatically gets updated.
Step 2: Total value of 550 appears in the cell.
Step 3: Now, drag the populated formula to get all the rows of the total column
Step 4: Select the values that need to be used for creating a dynamic pie-chart. Here, we are using the values calculated from the Offset formula. Click on Insert Menu and select the appropriate pie-chart.
Pie-chart gets inserted for the selected values.
Creating a dynamic pie chart using tables
We can also create a dynamic pie chart using tables. It is the easiest method for creating a dynamic pie chart. So to this follow the following steps:
Step 1: Create a table with proper headings and values inserted in it. Here, a table is created with Year-wise Sale, Tax, and Total(Sum of Sale and Tax) columns.
Step 2: Copy the headings and paste them separately. Here, Year, Sale, Tax, and Total are pasted separately.
Step 3: Select the column with the independent column(Year in the below table). Use Index Function and Counta function to bring the desired value for Year column.
Step 4: Use the Index and Count function for the dependent columns (Sale, Tax) to get their desired value for both the Sale and Tax column.
Step 5: Select the columns Sale, Tax, Total. Choose option Pie-chart from Insert menu. A dynamic pie-chart of the table will be created.
Step 6: Insert a new row in the table. The pie-chart automatically gets updated, as per the new row being added in the table. Here, the pie-chart gets updated for the row with the Year 2006.
