Impressive Add Lines To Chart In Excel
To add a new data series to your chart do one of the following.
Add lines to chart in excel. This will select the line and open the Format Data Series pane on the right side of your Excel window. Next right click anywhere on the chart and click Select Data. On the Format tab in the Current Selection group select the.
Click the worksheet that contains your chart. Press AltF11 on excel then VBE opens. Enter a new column beside your quantity column and name it Ver Line.
Enter the data for the vertical line in separate cells. To add a horizontal line to your chart do the following. Eg this will be useful to show data and highlight a current date.
Youll get a chart. Under Chart Tools on the Design tab in the Data group choose Select. Supposing you have created a column chart as below screenshot shown and you can add a horizontal average line for it as follows.
To add a vertical line to Excel scatter chart this is what you need to do. To add a vertical line to your line or scatter chart do the following. Select the entire table and insert a line chart with markers.
Select the column chart and click Kutools Charts Add Line to Chart to enable this feature. On the Format Data Series pane go to Fill Line tab Line section and select No line. To do this we can create a fake data series that shows the minimum and maximum value along the x-axis 0 and 20 as well as two y-values that are both equal to 20.