Wonderful Add Line In Chart Excel
To create a line chart execute the following steps.
Add line in chart excel. This will select the line and open the Format Data Series pane on the right side of your Excel window. Select the range A1D7. The range of data already displayed in the chart has been highlighted in the table.
Follow the steps on how to add a vertical line in Excel graph below. Go to Insert Illustrations Line. So now you have a column chart in your worksheet like below.
By way of example lets substitute 4000 for 1400 in yogurt sales. Press with left mouse button on the plus sign next to the chart. Find Charts-Insert Column Chart and select the first type.
Click and drag the bottom right corner of the selection to expand it to the Average column. The Easiest Way How to Add an Average line in an Excel Graph The easiest way to include the average value as a line into the chart is to click anywhere near the chart. Draw the line on top of the Chart.
Click at any place of the chart you want to add series line to show Chart Tools group in the Ribbon. Sometimes you need to add a horizontal line to your chart. In your graph double-click the target line.
Enter the data for the vertical line in separate cells. The resulting line extends to the edges of the plotted area but Excel changed the Axis Position to Between Tick Marks. Next step is to change that average bars into a horizontal line.