How to add a red straight line to an Excel column chart

php editor Apple today will introduce to you how to add a red straight line to an Excel column chart. In Excel, adding a red straight line can make the chart more intuitive and clear, making the data clearer and easier to understand. Next, let’s learn about the specific steps!

1. Select the data and insert [Clustered Column Chart].

2. Click the column chart of the target value, right-click [Change Series Chart Type], and change it to [Scatter Chart with Straight Line].

What I saw at this time was still a short red line. It doesn’t matter, keep reading.

3. Set the coordinate axis above the red line (the coordinate axis of the scatter plot). After selecting the coordinate axis, right-click [Set Axis Format] and set the minimum value of the coordinate axis to [1] and the maximum value to [5].

4. The coordinates on the left and right sides are not consistent, resulting in the actual value and the target value not being displayed in a proportion. Next we set the two coordinate axes to be consistent.

5. Basically it’s OK. Finally, enter the beautification step and remove the unnecessary coordinate axes. There is a trick for editing charts, which is [click where you want to change]. Be sure to remember it. We just click on the unnecessary parts of the line and surface, and then press the Delete key to delete.

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