Excel Tutorial: The number of men and women in Beijing, Shanghai, Guangzhou and Shenzhen is vividly reflected in charts

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. ヾ(◍°∇°◍)ﾉﾞ

I believe that many people have heard the above piece of Beishangguang not believing in tears. Today, I will share with you how to use Excel charts to show the distribution of men and women in the four cities of Beijing, Shanghai, Guangzhou and Shenzhen.

It is a pleasure to learn Excel tutorials with you all. What we're going to learn today is to make a personalized distribution chart of men and women in Excel. The effect diagram is as follows:

When we make the personalized chart above, we need to find Du Niang in advance, and search for the png image material you need to customize. For example, today's article demonstrates boys and girls. In actual work, you may want to show other objects. So here is not limited to boys and girls elements, we must learn to draw inferences from one case.

Click the mouse to open the Excel document that has been counted in advance. The data here is only for reference and case demonstration. The data of men and women in the four major cities of Beijing, Shanghai, Guangzhou and Shenzhen are randomly simulated. Select the cell data and insert a stacked bar chart.

Insert the prepared representative pictures of boys and girls into the table from the Insert tab, and adjust the size appropriately.

Select the inserted character picture, press the shortcut key Ctrl+C to copy, then select the corresponding boy/girl chart in the bar chart, and then press the shortcut key Ctrl+V to paste, the character is deformed at the beginning, don't panic, because Not yet adjusted.

Select the chart series, right-click to format the data series, and change the stretch fill to cascade in the paint bucket button.

After the two series of boys and girls are changed to be stacked, the width of the gap is adjusted to 30%, and the series overlap remains unchanged at 100%.

After the setup is complete, the rest is to beautify the details of the chart, adjust the font in the chart, add a title to the chart, align the legend in the upper right corner, add data labels, remove gridlines, etc.

The final effect is shown as follows:

The article concludes with a summary of the chart tutorial shared today:

By customizing the graph, copying and pasting it into the bar graph to make a personalized graph, in the whole graph making process, you need to prepare the required materials in advance, and finally the graph is beautified. It is recommended that you go to Netease Sudoku and other platforms to check Some visual charts can help develop your own aesthetic enhancements to charts.

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 ③: 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)