Shulou(Shulou.com)06/02 Report--

Today, I will talk to you about the skills of Excel chart operation. Many people may not know much about it. In order to let you know more, Xiaobian summarized the following contents for you. I hope you can gain something according to this article.

This article shares a few tips on how to operate diagrams. 1 Save chart as template

Making a chart can sometimes take a long time, modifying colors, beautification, etc. If you want to do a bunch of the same tone of the chart difficulty and all the steps again, do not need, just save the first time to do the chart as a template, the next time you can call out. As shown in the figure below, this column chart has set the gradient color, background, font and other effects. It is still time-consuming to do it again. Right-click Save as Template. In the pop-up Save dialog box, enter the template name and click Save.

At this time, if you want to insert a template chart for another group of data, just click [Insert]-[Recommended Chart], and you can see the template saved before in [Template]. Click it.

2

Select Chart Element

To select a column in a bar chart, click on the column to select all columns, and click on the desired column to select a single chart element. Select other elements in the same way, such as selecting data labels, clicking to select all labels, double-clicking to select the desired label.

3

Axis Settings

As shown in the figure below, the ordinate axis is a percentage of two decimal places. In fact, it is redundant. It is only necessary to retain integer digits. How to do it?

Right-click the ordinate axis to set the format of the coordinate axis. In the [Number] option, select the percentage category. Set the decimal place to 0, and the coordinate axis will be rounded.

4

Link to PPT

When copying and pasting a chart made in Excel into word or PPT, the original color format will be changed. What should I do? When pasting, choose to keep the original format, so what the original chart looks like in Excel is what it looks like in ppt. Or paste the chart directly as a picture, which is also possible.

5

Add chart data Copy and paste

To add a set of data to a completed chart, the conventional method is to select the data-add, as shown in the following animation, this operation is somewhat complicated, and the simpler method is to copy and paste directly.

Conventional methods:

Convenient method: copy and paste directly

6

Application of Secondary Coordinate Axis

When you want to represent two data situations with large numerical differences in a graph, you can use secondary axes to achieve this. As shown in the figure below, the data of the number of users is a bar chart in the chart, while the proportion of the number of users is displayed by a broken line chart.

For details, check the box of Last Coordinate Axis in Change Chart Type, or right-click Set Data Series Format for the data you want to set as Secondary Coordinates, and the series will be drawn on Secondary Coordinate Axis.

The animation below is a simple process of plotting data along secondary axes.

The secondary coordinate axis combined with the adjustment of the spacing results in the following two sets of data contrast histogram, which is better than the stacked histogram and can reflect a strong contrast relationship.

When making, set a group of data to be drawn on the secondary coordinate axis, and adjust the gap width at the same time, as shown in the following animation.

7

Reverse order scale value makes cyclone diagram effect

By applying the function of inverse scale value, the effect of cyclone diagram as shown in the following figure is obtained, that is, two sets of contrast data are distributed on the left and right sides of the plane.

Insert a bar chart first, and set a group of data as the secondary coordinate axis. The key point is to set the secondary coordinate axis as the reverse scale value in the coordinate axis option, and set the symmetry of the primary and secondary abscissa values.

The specific steps can be referred to the following dynamic diagram.

Today's sharing of chart operations is here.

After reading the above content, what are your skills for Excel chart operation? Do you have further understanding? If you still want to know more knowledge or related content, please pay attention to the industry information channel, thank you for your support.

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.