How Excel imitates the rotation button doughnut chart

how Excel imitates the rotation button doughnut chart

The resulting effect is shown in the following illustration. This chart is characterized by the overall shape similar to the radio, fans or other mechanical panels on the rotation button, as the data changes, the direction of the knob pointer will automatically change with the outer ring, while both dynamic and three-dimensional, suitable for dashboard and other dynamic chart scenes. You can often see the dashboard charts used in dashboard, or you can refer to similar methods for implementation.

The following specific implementation methods are suitable for Excel2007 and above versions.

Step 1:

The first is data preparation work. The data required by the doughnut itself consists of two of data, in which the two data are assigned a 360-degree sector angle. Now you need to add two columns of secondary data, the first column of secondary data consists of 3 numeric 1, and the second column of secondary data is inserted in the middle of two raw data to form 3 data, a fraction of which can be taken separately from the data on both sides to keep the sum of the values unchanged. In this example, the median value is removed from both sides by 5 and then added together to Form 10.

This secondary data will be used in the future to generate pointer marks on the knob, so the middle portion of the value actually represents the center angle position of the knob pointer.

Step 2:

Create a doughnut chart with the original two data.

Step 3:

Continue to add the first column of secondary data (3 data) and second column secondary data (3 data) to the diagram to form a 3-layer circle. Easier to do: Select two columns of secondary data and press "CTRL + C" Copy, then select the chart, press "Ctrl + V" Paste can be.

Step 4:

Use the Select Data command to adjust the series order with the up and down arrows in the data Series dialog box, move the second secondary data series to the top, and move the original data series to the bottom. What is shown on the chart is that the original data (two-segment rings) is displayed at the outermost level, the first column of secondary data series (three-segment equal-length ring) is displayed in the middle tier, and the second column of secondary data series (three-segment unequal ring) is displayed in the outermost layer.