Shulou(Shulou.com)11/24 Report--

Hello, everyone. I'm Yali.

Learn a little Excel every day, work efficiency up~up~

Early this morning, my colleague came up to me and told me that she was too difficult.

The boss asked her to make a chart based on the 12-month data, and she also revised it back and forth several times according to the request, but the boss was not satisfied and asked her to go back and revise it with a poker face.

I was wondering if the boss was in a bad mood recently, but when I took a look at it, all right.

Sister, this is asking you to make charts, not rainbow candy. (in the words of the boss: it is simply vulgar and not cute! )

When there is a lot of data, we generate charts directly, which is often messy.

At this time, with a little processing, you can make a dynamic chart like the following.

Let's take a look at it together.

Specific operations:

❶ first makes a drop-down list.

①, select any blank line under the source data and fill in the header:

② click "data"-"data tools"-"data validation". In the pop-up dialog box, change the condition of "allow (A)" to "sequence".

In the "Source" box, select all the names in the table above as the content of the area, and then click "OK".

❷ then uses the VLOOKUP function in the B16 cell to match the corresponding data.

Enter the formula:

= IFERROR (VLOOKUP (A16 grammatical Ascen4displacement Glos12heroic column (B3), 0) Note: the COLUMN function is nested in VLOOKUP to drag the fill formula to the right without changing the returned column number.

Click enter.

Meaning of the formula:

Using the IFERROR function, we can return the specified result when there is an error in the formula calculation. If the calculation is correct, the result of the formula is returned.

VLOOKUP (B3) includes four parameters:

Parameter-A16: indicates the value to look for

Parameter 2$ A$4:$G$12: indicates the scope of the search

Parameter 3 COLUMN (B3): represents the column relative to A16 cell

Parameter 40: indicates an exact match.

Finally, ❸, select the two rows of data, click the insert tab-Chart, and select Cluster column Chart to generate a chart.

In this way, the dynamic chart is finished.

Sift through people's names, and the chart will change with it, making it much clearer and more beautiful.

So, this dynamic chart is amazing, isn't it? Take it quickly and hand it over to the boss.

That's all for today's content sharing. I hope it will help you all.

If you learn a trick every day, your work is not bad!

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Yalizi, Editor: Zhu Lan

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.