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

The original title: "how is this beautiful Excel line chart made?" "

Hi, I am the uncle Mr Zhao who prefers function formulas and likes to use Excel charts to manage warehouses.

Xiaoming is a salesman of a company. The following table shows his performance data for 12 months a year.

If we use the default method of Excel to make a line chart to show Xiaoming's performance changes over the past year, it will look like this:

The line chart presented in this way is too monotonous and looks a little down-to-earth.

So how do you make a good-looking line chart?

For example, to make this bridge line chart, each data point is marked and underneath is supported by a gradual line.

In this way, the chart will appear more intuitive and three-dimensional. The grade has been improved a lot immediately.

Here is a detailed description of the steps for making this chart:

❶ select any cell in the data area, open the [insert] tab-[recommended Chart]-[Line Chart]-Select [Line Chart with data tag].

❷ adds the data label and changes the label position to [up].

❸ right-click on the line chart-[format data series].

Line settings: solid red lines

Data tag setting: type is circle, size is 8, white fill, red border.

❹ select the chart, click the [+] sign in the upper right corner of the chart, and check [error line].

Set the direction of the vertical error line to negative deviation, the end style to the wireless end, and the percentage of error to 100%.

❺ sets the error line to a gradient line with a red aperture on the left and white on the right.

❻ finally deletes gridlines, ordinate axes, and modifies the chart title, as shown below:

If you still want to compare Xiaoming with other salespeople to see what level Xiaoming is at.

How to make a chart?

We can put the company's worst and best salesman performance into the following table, as shown in columns C and D below.

Then, based on the data, make this line chart that walks in the river:

This line chart displayed in the range, let us see clearly: "although Xiaoming's performance is stable, he has been lagging behind other colleagues." "

Here are the steps for this chart:

❶ first adds a secondary column, enters the following formula in the E2 cell, and then fills the formula down:

= D2-C2

❷ selects AME column C and column E, and inserts a default line chart.

❸ select any series of charts and right-click-[change Series Chart Type]. Change the "worst performance" and "auxiliary column" series to [stacked area chart].

❹ sets the data series format.

The color of the "Secondary column" series is filled in red and the transparency is 80%.

The line color of "Xiao Ming's performance" series is set to red.

The "worst performance" series is set to colorless filling.

❺ finally modifies the title of the chart to add indication tags to beautify the chart.

In this way, the chart is finished!

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Zhao Jiaoyang

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.