Now, from the Charts group section you have to choose 2-D Line > then choose Line with Markers.įurthermore, there are 6 features under the 2-D Line.Secondly, you have to go to the Insert tab.In addition, you want to add a vertical line of Average Cost. You can use the Bar Chart feature to add a vertical line in Excel Graph. Use of Bar Chart Feature to Add Vertical Line in Excel Graph Read More: How to Add a Vertical Dotted Line in Excel Graph (3 Easy Methods)Ģ. Now, from the Charts group section you have to choose Scatter > then choose Scatter with Straight Lines and Markers.Īt this time, you will see the following graph with an added vertical line.Īlso, I have changed the Chart Title to “ Adding Vertical Line”.Hence, you need to write these as the following format. Here, the X and Y values for the new point of the adding line will be respectively Average Cost value and Average Sales value.This means the Cost value will be in the X direction and the Sales value will be in the Y direction. Suppose, you have the following dataset and you want to add a vertical line with the data Average Cost and Average Sales which are given below the dataset.įurthermore, let’s assume that the graph should be Cost vs Sales.
You can add a vertical line in the Scatter graph. In addition, for your better understanding, I’m going to use a sample dataset. Here, I will describe 6 methods to add a vertical line in an Excel graph. 6 Methods to Add Vertical Line in Excel Graph
0 kommentar(er)
