Excel tutorial: learn this trick to make your histogram no longer monotonous

Tanabata romantic date "Hui"

Super Member Lifetime Card 23% off for a limited time

The original price is 168. Sign up today for only 129!

Don't miss it. ヾ(◍°∇°◍)ﾉﾞ

Tanabata romantic date "Hui"

Super Member Lifetime Card 23% off for a limited time

The original price is 168. Sign up today for only 129!

Don't miss it. ヾ(◍°∇°◍)ﾉﾞ

Today, Xiao Ai saw in the background of WeChat, some friends complained that the histogram that comes with Excel is a little monotonous, and asked if there is any way to make the histogram more vivid, such as the effect made in other people's web pages, as follows:

In fact, like this effect, Excel can also be achieved, not much nonsense, let's add some material to the histogram today. Here we make a bar chart of the top five gold medals in the 2016 Rio Olympic Games as an example. The data is shown in the following table:

First of all, we need to find a picture in PNG format on the Internet. In order to adapt to the theme of the gold medal list, the editor found a picture of the gold medal, which looks like the following. However, the pictures on the Internet are generally relatively large and need to be reduced. It is more appropriate to adjust their size to about 400 pixels.

Next, we achieve the effect we want in two ways.

Method 1: Column chart picture filling and stacking method

This method has a long history. It directly uses the original gold medal data to generate a horizontal column chart, as shown in the following figure:

Then in the set data point format fill, select the image or texture fill, the image source select the gold image above, and the image insertion method select cascading, and it's OK.

But the disadvantage is also obvious, that is, some of the filled medal pictures will be incomplete, and it is difficult to make all series of medal pictures complete by adjusting the width of the gap. So here is another method.

Method 2: Scatter Plot Custom Data Labeling

To achieve the effect in the web page, we need to expand the data source, and expand the annual data (denoted as N) into an arithmetic sequence between 1 and N/k (k is an integer) according to a certain ratio (here, take k It is 2, the reason for dividing by k is to prevent too many icons and affect the appearance) as the x-axis data, and the y-axis data is a constant column (1-5 here, purely to distinguish different series, can take any number), expand The completed data is shown in the following figure:

Next, generate a scatter plot based on the expanded data, which is 5 horizontal lines to put it bluntly.

Next is the most important step, don't blink, select a series, open the "Data Series Format" panel, check "built-in" in the marker options, select "image" in the pop-up marker type drop-down box, and then click In the picture selection window that appears, find the picture we downloaded and select it, as shown in the following figure:

A magical scene appeared, the original data markers were replaced with medals, and then we could do the same for the remaining series, and we were done. Does it look like that?

It should be noted that in this process, it may be necessary to adjust the size of the PNG image to fit the entire chart. It should not be too large. If it is too large, the images may overlap each other. From our experience, about 400 pixels is more suitable.

That's all for today's sharing. If the tutorial is useful to you, I hope you will share and support the editor! Every like and repost of yours is the motivation to support the editor to insist on originality.

Why choose us, the platform advantage is there

Advantage ①: VIP can learn all tutorials, unlimited learning + supporting material source files + unlimited downloads

Advantage 2: Support WeChat public account + applet + APP + PC website for multi-platform learning

Advantage 3: Support offline viewing, double-speed viewing, allowing you to learn anytime, anywhere

Advantage ④: VIP logo, distinguished status + independent after-sales group answers

★ FAQ ★

①Xiao Ai: Can you watch all the courses after buying VIP ?

Well, yes, including future updates (thanks for your support, we will insist on high-quality teaching updates)

②Xiao Ai: Hello, how do you study ?

Pay attention to the Aizhiqu Education Service Account, you can directly enter the official website to learn from the menu navigation, or you can enter the applet and download the APP!

Computer login to https://www.92zhiqu.com

(Mobile phone, computer learning is essential)

③Xiao Ai: what to do if you do n’t understand

Provide after-sales answers, pay to contact customer service and join the group (pay to contact WeChat customer service, just take a screenshot)

④Xiao Ai: Provide video courseware materials ?

Well, original high-definition video, these are provided (original tutorial, these are the most basic requirements)

⑤Classmate Xiao Ai: Validity period of study ?

Annual membership and lifetime membership, unlimited lifetime membership (self-built website + original tutorial + Aichiqu brand guarantee)

⑥ Primary school students: Does the website support accelerated viewing ?

kindness. At present, mobile phone applet + APP + computer PC all support 1.5 times accelerated viewing or slow playback

⑦ Does the course support offline download ?

kindness. Both Android and Apple IOS APP support mobile phone offline download

Computer downloads are provided by contacting WeChat customer service 18074746783.

⑧ How about the quality of the course ?

Aizhiqu Education high-quality video as the starting point, high-definition subtitles, support for audition

If there is anything else you need to consult, please contact WeChat customer service 18074746783

Long press to identify the QR code "Add Customer Service"

Click to read the original text , log in to the official website with one click, and learn from a large number of video VIPs! (you can try it out)