Great Draw Line In Excel Chart
You get a column chart with a second set of columns or a line chart with a second line.
Draw line in excel chart. In the Insert tab under illustrations click on shapes. Select the first Line chart the one highlighted in the image above. 1Beside the source data add a Forecast column and list the forecast sales amount as below screenshot shown.
Enter a new column beside your quantity column and name it Ver Line. From the Design tab choosethe Chart Style. Line Chart in Excel.
Line Chart is the graphical presentation format in excel. In the Add line to chart dialog please check the Average option and click the Ok button. The easiest way to add vertical line to Excel chart is to draw a line on top of the Excel Chart using shapes.
To create a line chart execute the following steps. The line charts are fantastic tools in Excel to visualize records over time. From the dialogue box the left hand side shows all the chart templates.
This step by step tutorial will assist all levels of Excel users in the following. Change the chart type of the added series to a line chart without markers. Select the column chart and click Kutools Charts Add Line to Chart to enable this feature.
First of all select the data table and insert a column chart. Go to Insert Illustrations Line. Go to Insert Line Charts Line with Markers.