Shulou(Shulou.com)06/01 Report--

This article introduces the relevant knowledge of "what is the method of making EXCEL dynamic dashboard". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

The effect picture is as follows

Dashboard dynamic chart demonstrating data preparation the dashboard is made up of two circle charts plus a pie chart. Among them, the scale value is used for the data label of the dashboard, the dial value and color value are used as the circle chart, and the pointer value is used as the pie chart. Scale value: the maximum value of 150 is divided into 10 parts with an interval of 15; dial value: a circle is 360 °, which is divided into 270 °and 90 °, of which 270 °is divided equally, each 27 °, as a space-occupying data; color value: divide the circle 4, each marked with a color; pointer value: the first data is equal to the index value * completion ratio / maximum value * 270 The second data equals 1.5 (fixed value) as a placeholder data; the third data equals 360-fixed value-the first data.

Graphic operation 1. Select dial value data and insert a circle chart.

2. Right-click on the chart to select data.

3. Click add data.

4. the series name adds the color value, and the series value adds 4 values of the color.

5. in the same way, add the pointer value.

6. Double-click the circle chart, set the data series format, and set the starting angle of the first sector to 225 °. 7. Click the donut chart and click to change the series chart type.

8. Set the pointer value chart type to pie chart and check the secondary axis. 9. Double-click the circle chart and set the data series format. The starting angle of the first sector is set to 225 °, and the pie chart separation is set to 60%.

10. Double-click to select the pointer value, set the outline of the shape to red, select 2.25 pounds in thickness, and set the other two fan-shaped areas to no filling. 11. Right-click the inner circle chart, and click add data label. 12. Cancel the value, check the value in the cell, select the scale value, and let the table present the scale value. 13. Click the inner ring and set the fill to no fill and the border to no lines.

14. Set the filling color, the first ring area is set to no filling, the second ring area is set to red, the third ring area is set to red to green gradient filling, and the fourth ring area is set to green. 15. Copy the value of the completion ratio and paste it into the format of the linked picture.

16. Combine the linked picture with the chart, delete the legend and add the chart title.

17. Add data validation to generate dynamic dashboards.

This is the end of the content of "what is the method of making EXCEL dynamic dashboard". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.