How to add a horizontal line to a scatter chart in Excel

How to add a horizontal line to a scatter chart in Excel?

First, add a scatter plot based on the two columns of data

Calculate the average, add a legend item "Average", and add You can see a blue point added in the point diagram

##Select menu->Insert->Shape->Line, select the straight line, and select the blue point from In the legend, start drawing a straight line and keep it parallel to the x-coordinate axis

Set the line thickness to achieve the observation effect of the average line in the scatter chart

For more Excel-related technical articles, please visit the

Excel Basic Tutorialcolumn!

The above is the detailed content of How to add a horizontal line to a scatter chart in Excel. For more information, please follow other related articles on the PHP Chinese website!