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

Original title: Advanced Chart| Live your head a little bit, and the chart is beautiful."

Total number of words: 1394

Estimated reading time: 4 minutes

Hello, everyone. I'm Ann Ayn.

Today, I will bring you three different types of charts. The difficulty is not great. You can open the PPT and try it.

01. Column division form uses white color blocks to divide columns, which is both beautiful and better able to distinguish data from different years:

Next, let's look at specific practices.

First, insert cluster bars and edit the data:

The current maximum is a bit small, resulting in the tallest cylinder being too tall for subsequent insertion of data labels.

You can adjust the maximum value of the primary ordinate axis to 50:

Then make the white column part separated, as shown in the following figure, edit the data, enter the maximum value of coordinate axis every other line: 50

Select Chart, Chart Design-Change Chart Type, Set Series 1 as Secondary Axis:

Change the maximum value of the secondary axis to 50, which needs to be consistent with the maximum value of the primary axis.

Then modify the gap width of series 1 and series 2, and set the appropriate width:

Change the color of the cylinders one by one and add data labels:

Add the title and the body text to see the final effect:

Next, learn the second chart together.

02. Divide the highlighted data This chart uses the same method as the previous 'Edit Data' and on this basis the columns have been changed to rounded corners:

First, insert cluster bars and edit the data:

Then enter the data for series 2, enter 50 (data consistent with axis max), but don't enter every other line:

Change the maximum value of the ordinate axis:

Change the chart type again, set the secondary axis for Series 1, and modify the color:

Delete the chart title, gridlines, and legend, copy the chart and selectively paste as an enhanced metafile, ungroup twice:

At this point, you will find that the white cylinder is a whole, not a scattered rectangle:

For this step, you need to use iSlide plug-in-design tools-vector-cancel compound path:

After clicking, it is split into 10 separate rectangles:

Then select all rectangles:

Change shapes to rounded rectangles:

You can then adjust the handles of all rounded rectangles through iSlide Plug-in-Design Layout-Handle Adjustment.

Insert data label text and format the data:

Insert a rounded rectangle and triangle, merge them into a dialog box shape, and enter the data you want to highlight:

Add the title and text content, and the final effect is as follows:

Tip: If you are using it yourself, it is best to keep a copy of the source data for subsequent modification and adjustment.

Continue to see the third chart ~

03. The effect of the third chart is as follows:

First, insert a torus:

Although PPT has its own pie chart, it cannot change the style to ring, so it needs to use two additional ring charts as child and parent.

Select the chart and edit the data:

Change the color of each ring and resize the rings to fit.

After the adjustment, copy and modify the data of the second circle chart:

As shown above, I have resized the image according to the parent image and child image.

Then insert a trapezoid representing the relationship between the two graphs:

Set the trapezoid to gradient fill, insert an extra circle about the same size as the inner ring of the parent graph, and Boolean operation with trapezoid.

Select trapezoid, then circle, Boolean operation-subtract:

Insert two gradient arrows as modifiers and enter the name and data in the circle:

Below the doughnut chart, use a table to show the specific data of the two doughnuts.

Also connected by gradient trapezoid, the side parallel to the top trapezoid, the effect is better:

At this point, the third chart was completed. It was not difficult, but the style change was worth learning. It looked good and easy to use:

Finally, let's review the three charts for the essentials:

01. Split the chart using secondary axes

02. Creative expression using metafile

03. Child charts show data relationships

That's all for this tutorial.

This article comes from Weixin Official Accounts: Self-disciplined Music (ID: yinlvPPT), by An Ayn

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.