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

This article is to share with you about how to make an Excel dynamic chart, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

This article explains

The picture below is a cool Excel dynamic chart, and the hardest part is using a check box control. In fact, I have seen this control a long time ago, but I can't use it! lament one's littleness before the vast ocean. This time, I also use this article to tell you about the use of this control. This article does not use any advanced function, that is, a few simple steps can achieve the production of this chart, read and learn.

The final effect shows 1. Call up the development tool control in excel

The development tool is called up for later use of check box controls. But the initial installation of excel does not automatically display the development tool, so we need to call it up manually. If you can't call it up, take a look at the dynamic chart below me.

two。 Copy the original data source to the chart source

Copy the source data, paste it, rename it to the chart source, and delete the data in the chart source

3. Create a check box control area

4. Insert check box

Step 1: insert a blank area to facilitate the subsequent use of check box controls and insert charts

Step 2: insert 4 check boxes in turn

Step 3: change the name of the check box

Step 4: format the check box

① adjusts the position of the check box control

② adjusts the color of the check box control

5. Set the connection for the check box

Note: each check box has its own connected cell, after the connection is successful. Check the box to show Ture, do not check the box to show False, everyone take a closer look.

6. Set up data for the icon source

V: a NA () function is used here, and most people probably don't know how to use it. I give you a picture here for your reference.

After understanding the above functions, let's take a look at the formula in the following figure and have a good experience.

7. Insert a chart

Step 1: insert the chart, select the data source, and get the chart we finally want.

Step 2: set the sales volume and unit price to the line chart, and their units are both 1, so they are all represented by secondary axes.

Step 3: adjust the chart format, delete the title, and display the legend directly above the graph. If you want to adjust other formats, please go down and try it yourself.

The above is how to make an Excel dynamic chart. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

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.