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

Author: Satellite Sauce

Editor of this article: Zhu Lan

Homemade bar charts are so crude they cry?

The inserted bar chart doesn't agree?

The funnel you wanted was so ugly you had to give it up?

This article may help you solve your problems!

Satellite sauce recently noticed a small function that was usually not very eye-catching-[REPT function].

The syntax of this function is simple: repeat a character a specified number of times.

You may wonder: Isn't it about charts? Why did you suddenly say functions?

Take it easy! This REPT function can also produce these three beautiful commonly used charts ~

Small function, big energy! Without hesitation, let's go dry goods

1. Bar Charts Bar charts are very common charts. To make them, we need:

Number of data, REPT function, Playbill font set, vertical bar symbol "|"A few, add color according to individual taste.

Production steps:

Enter the formula at C3:

=REPT("|",B3/10) The"/10 "in the formula controls the length of the bar graph.

Then drop down to fill C3-C9, modify the font to Playbill, you can get a simple and beautiful bar chart!

If you don't think black is bright enough, you can also make it more beautiful by modifying the font color ~

PS. Here's "|"is a vertical line symbol, usually located directly above the Enter key, to cooperate with the Shift key to type ~

Column charts are also common and can be used to compare data between different categories. To make it is to change the direction of the bar graph!

Preparation:

Number of data, REPT function, Playbill font bag, vertical bar symbol "|A number of cell formats are spoonfuls, adding colors to suit individual tastes.

Production steps:

Enter the formula in B5 as shown below, and then fill it in the same way. Don't forget the font Playbill ~

=REPT("|",B6/10)

Then set the cell format to change the direction of the text, but also according to their preferences to change the color it!

Press Ctrl+1 to open the Set Cell Format dialog box, and select:

[Horizontal alignment]-[Center]

[Vertical alignment]-[Bottom]

[Direction]-[90]

3, funnel chart funnel chart and bar chart production principle is the same, different only numerical sorting:

Take out the bar chart before, modify the data sorting to [descending order] is a [funnel chart],[ascending order] is an inverted funnel ~

Here's the formula we'll modify to make the chart look better:

=REPT("|",B3) Then set the text alignment mode to [Center], and change the data sorting according to the requirements ~

Well, isn't that easy?

4. Write at the end Today we have made 3 beautiful charts with very simple formulas and very simple operations:

Bar chart

Bar chart

funnel diagram

Most importantly, they are integral to your tables and don't go wrong when you transfer data like inserted charts or hand-drawn charts!

(Narrator: Hand-drawn data cannot be synchronized, inserted charts, once copied to another table, there is no way to synchronize data! But these REPT charts are different, they can be copied along with the data!)

In addition to the above charts, the inconspicuous REPT function can also be used to make cyclone charts, star charts and Gantt charts. Due to space constraints, I will only talk about this today. If you want to learn the method of making other charts, please continue to pay attention to it for later articles ~

Oh yes, we can expand on these charts! Like putting numbers or other elements on a graph. Do you know how to do that? Welcome to communicate in the comment area ~

This article comes from Weixin Official Accounts: Autumn Leaf Excel (ID: excel100), Author: Satellite Sauce

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.