How to make two lines in Excel line chart How to display two lines in Excel line chart

WBOY
Release: 2024-08-29 13:09:20
Original
241 people have browsed it

In Excel tables, we can display data through line charts or fan charts. Many users want to know how to make two lines in Excel line charts? Regarding this issue, let me share with you the specific operation method. I hope that today’s software tutorial can answer users’ questions. Let’s take a look at the detailed steps. How to make two lines in Excel line chart: 1. Compile two sets of data at random. The values ​​and quantities of the abscissas of these two sets of data are different. It is required to make these two sets of data into a line chart.

Excel折线图怎么做两条线 Excel折线图显示两条线操作方法

2. First select the first set of data, click Insert>Scatter Plot> and select the scatter plot with straight lines and data markers (the second one in the second row).

Excel折线图怎么做两条线 Excel折线图显示两条线操作方法

3. Select the generated scatter plot with straight lines, right-click and select Select Data.

Excel折线图怎么做两条线 Excel折线图显示两条线操作方法

4. Click Add in the pop-up Select Data Source dialog box, and enter the position of the second set of data x values ​​in the x-axis series value in the pop-up Edit Data Series dialog box. Enter the Y-axis series value into the position of the y value of the second set of data, and click OK.

Excel折线图怎么做两条线 Excel折线图显示两条线操作方法

5. As you can see, the line graphs corresponding to the two sets of data have been added to one graph. The next step is to perform some simple beautification of the graph.

Excel折线图怎么做两条线 Excel折线图显示两条线操作方法

6. After selecting the graphic, right-click and in the format of the drawing area, you can modify the border style and color. Select the polyline and right-click to modify the line color and thickness in the format of the data series. After beautification, you can get a satisfactory double line chart.

Excel折线图怎么做两条线 Excel折线图显示两条线操作方法

The above is the detailed content of How to make two lines in Excel line chart How to display two lines in Excel line chart. For more information, please follow other related articles on the PHP Chinese website!

source:xpwin7.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!