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

Total of this article: 1533 words

Estimated reading time: 4 minutes

Hello, I'm Ann Ayn.

It's time for Crazy Thursday's regular column, eat K and learn charts with me.

This issue teaches you to do three commonly used line charts, the grid is full!

Let's learn and do it together.

01. The information is clear at a glance. The first line chart adds lines on the original basis to simulate the context of the mountains, which can better see the ups and downs of the data:

But is it really an extra line insertion? Can it be changed automatically after changing the data?

First, insert the line chart and edit the data:

To select a chart element, simply check the main Abscissa:

Next, align the chart to the guides:

Select the chart, open to format the shape, select the tag, and then select the built-in, type selection circle in the tag options, and adjust to the appropriate size:

Looking at the original picture, it is hollowed out in the middle:

However, when we set it to no fill, we don't get the same result:

In another way, we can change the fill to a solid color fill and absorb the background color:

Next, add the vertical bar below.

Select the chart, edit the data in the chart design, and add a list of the same data:

Then change the chart type, select the combination chart, and change the chart type of column 1 to a clustered column chart:

Insert an additional rectangle, set linear to the right, three gradient apertures, Aperture 1 and Aperture 3 are 100% transparent white, Aperture 2 is light blue-gray:

Adjust the position of aperture 1 to 49% and the position of aperture 3 to 51%:

Select the rectangle, copy or cut, then select the chart, and change the filling method to picture or texture filling:

Then select the data label and change the key data to color label:

Add the text and make a simple layout:

So, did you ever think of using a cluster column chart?

Next order ~

02. Add a shadow to a smooth line chart to make it look unique:

The first step is to insert the line chart and edit the data:

This chart mainly highlights smooth broken lines, so we weaken other chart elements:

Select the chart, format the shape-lines, and check the smooth line at the bottom:

After smoothing, change the line color, select the data in 2020 columns, and change the marking option to built-in, with the type circle and the appropriate size:

The marking option is filled with solids, allowing the audience to see the data that needs to be highlighted at a glance.

Insert additional rounded rectangles and triangles to simulate a simple dialog box as a data substrate:

It's almost done, but it still lacks the soul.

Add a shadow effect to it, and be careful that the shadow is not too obvious. The feeling of seeming nothing is the best:

Add the simple typesetting of the text to see the final effect:

Is it simple and advanced?

Next, take a look at the third chart.

03. Smooth gradient fold line this chart adds a color block on the basis of the previous smoothing, you can think about, how do you do this?

That's right! Added a set of area maps and used gradients to make the chart more beautiful.

First insert the combination chart, select the line chart in series 1, and select the area chart in series 2:

Edit data, series 1 and series 2 are the same data:

Chart elements can only leave horizontal and vertical axes, simple and advanced ~

Next, modify the color and text to change the broken line to a smooth line:

But in this way, the smooth broken line and area map do not fit.

There are two ways to do this.

The first method is to adjust the gradient color of the area map to highly transparent orange, with the first aperture more than 80% and the second aperture 100%:

Visually, it is possible to confuse the fake with the real.

The second method is to copy or cut the chart and selectively paste it as an enhanced metafile:

Then unassemble it twice:

As you can see, the original broken line has become a shape.

Make a copy, first select the orange area map, and then select the black broken line graph, Boolean operation-subtraction:

The corner of the shape is smoothed.

Finally, group it together and modify the gradient:

Perfect fit ~

In fact, there is a third way to post video tutorials in the community before. If you are interested, you can open it and have a look at it: https://qpq.xet.tech/ s / 3Cpcdn

Simply add the text to see the final effect:

Add a packaging prototype, add a little animation, and get it done:

Finally, let's review the knowledge points of the three charts:

01. Fill it with combined charts and pictures

02. Line chart smoothing and adding shadows

03. Superposition of line chart and area chart

The above is the whole content of this chart tutorial.

This article comes from the official account of Wechat: self-discipline Rhythm (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.