How Excel makes beautiful dynamic doughnut charts

How Excel makes beautiful dynamic doughnut charts

The data are as follows:

Drawing steps:

First, insert a control button.

Development tool--insert--combo box.

How the development tool brings up: file--Options--Custom Ribbon--Main tab--development tool (tick).

After drawing, click the control right--set the control format.

When you set a control, the number of linked cells changes as you select the Drop-down box for the control.

The returned number is the relative position of the selected data in the control in the range, consistent with the result returned by the match function.

Effect:

Build the data.

Copy the table title, go to A9:e9, enter the formula in A9, and pull right.

Formula Resolution:

Use index to extract the data for the first row, $B 7 cell is the control-linked cell, and the data changes as the control changes.

In A11 cell enter: Blank placeholder.

Enter the formula in the B11 and pull right:

This assumes that the maximum value of a circle is 650.

To create a chart:

Select the built data insert-doughnut chart.