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

The original title: "I've never seen a chart like this before. it's awesome!" 10 tips for chart making! "

Are you still using the default chart that comes with Excel? Isn't it corny? In fact, we can also use symbols to make charts in Excel. You haven't heard of it. Today, I would like to share with you ten cases to teach you how to make beautiful charts with symbols.

01. Bar chart

Formula:

The = REPT ("|", B2) REPT function can repeat the defined content as many times as it is defined.

At this point, we can see that the cell has been filled with vertical bars "|". We just need to change the font color, and the bar chart is finished. If you don't like the default vertical bar effect, you can change the font to "Playbill" and become solid.

02. Funnel chart

Formula:

= REPT ("|", B2ap10) funnel chart is similar to bar chart in production, but with one more center alignment. I added a "/ 10" to the formula because by default the bar is too long to affect the effect, divided by ten will shorten a bit.

03. Column chart with negative number

Positive number formula:

= IF (B20 minus REPT ("|", B2), ") negative number formula:

= IFB20,REPT ("|", ABS (B2)), "" ABS takes an absolute value function and returns a negative number to a positive number.

The font "Playbill" (of course, you don't have to change it if you like the default vertical bar style), the negative numbers need to be aligned to the right.

04. Gantt Chart

Formula:

= REPT (", B2-MIN ($B$2:$B$6)) & REPT (" | ", (C2-B2)) REPT we have already said that the defined content can be displayed repeatedly according to the number of times defined.

B2 here is the planned start date, minus MIN ($B$2:$B$6), and the MIN function is the minimum value returned, which refers to the smallest date in the column "scheduled start date". In this way, you can get the time difference, and the difference displays a space.

& Connector, the bar chart behind the connection.

05. Whirlwind comparison map

Formula:

= REPT ("|", B2CP5) = REPT ("|", C2Uniq5) font "Playbill", and then change the color.

Effect of whirlwind comparison 2

Formula:

= B2 & "& REPT (" | ", B2pin15) = REPT (" | ", C2Univer 15) &" & C2 the second style, with data, may be more intuitive. Just use the default font and change the color. A & connector is added to the formula to connect directly to the data cell, separated by spaces.

06. Column chart

Formula:

= REPT ("|", C5) fill to the right, then change the font to set the color.

At this point, the column chart is horizontal, we select the column chart, and then "right"-"format cells"-"align", set it to "90" degrees in Direction. Then click bottom alignment and Center in alignment.

07. Figure chart

Formula:

= REPT ("blank", B2ap4) is actually the same as a bar chart, except that the "|" vertical bar is replaced by a "human" symbol.

08, five-star score

Formula:

= REPT ("★", B2) & REPT ("☆", (5-B2)) generates ★ based on the "comprehensive score" data; & connects the 5-b2 comprehensive score to get the rest of the value, which is shown as ☆.

09. Love score

Formula:

= REPT ("♥", B2) & REPT ("♡", (5-B2)) is the same as the above five-star score, except that the special symbol is replaced.

10. Percentage chart

Formula:

= REPT ("□", (1-C4) * 100) & REPT ("■", C4x100) 1, "right"-"format cells"-"align"-"text control"-"automatic line wrapping". Drag the width and height of the cell so that each line displays only 10 characters. (the default contours of the font)

2. Beautify and set the font color and background color.

3. You can also change the square into a circle, which is another effect.

= REPT ("○", (1-G4) * 100) & REPT ("●", G4000100)

Tip description:

Different fonts will have different effects. Bar and column charts are vertical bar "|" effect by default, and solid effect can be switched to "Playbill" font. You can try more, other fonts may have a better effect!

If you think the chart is too small and too thin, you can enlarge the font size.

The data is too long, so the chart is very long. You can use "/" divided by 2, divided by 5, divided by 10 to shrink the chart. If the data is too short and wants to lengthen, you can follow the opposite way of thinking, "*" multiplication.

There are so many special symbols, you can replace them at will and use them flexibly!

This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Wang Wangqi

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.