Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How To Create A Dynamic Graph In Microsoft Excel

Date:2022-7-1 Author:Sandra

Why can the data in the Excel chart made by other people be selected? And the corresponding chart will change along with it. Today we will learn how to make this kind of chart that can switch data in one second.

Let’s first create a table to give an example.

How To Create A Dynamic Graph In Microsoft Excel

We first copy and paste the first row of the table below.

How To Create A Dynamic Graph In Microsoft Excel

Select cell A11 and go to the Data tab to choose Date Validation.

Allow list and select the source A2:A7.

How To Create A Dynamic Graph In Microsoft Excel

Now we will find a drop-down menu in cell A11.

How To Create A Dynamic Graph In Microsoft Excel

Type =VLOOKUP(A11,A1:E7,2,0) in cell B11 and press Enter key and fill right.

How To Create A Dynamic Graph In Microsoft Excel
How To Create A Dynamic Graph In Microsoft Excel

When we change the fruit type in cell A11, the sales volume on the right will also become corresponding.

How To Create A Dynamic Graph In Microsoft Excel

Highlight the watermelon sale from January to April and insert a chart.

How To Create A Dynamic Graph In Microsoft Excel

If we change the type of fruit from watermelon to kiwi, then the watermelon chart will immediately become a kiwi sales table.

How To Create A Dynamic Graph In Microsoft Excel
How To Create A Dynamic Graph In Microsoft Excel
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *