Marvelous Add Multiple Lines In Excel Graph

Figure 2 Line Chart with two series revised view Observation.

Add multiple lines in excel graph. Extract or Remove Part of Texts. Multiple Workbooks and Sheets into One. 2 Select Fill Line.

Navigate to Insert - Charts-Combo-Clustered Column-Line on Secondary Axis Below is the chart Microsoft Excel inserted by Default. Sometimes you need to add a horizontal line to your chart. Beside the source data add a Benchmark line column and fill with your benchmark values.

In the Select Data Source dialog box click the Add button in the Legend Entries Series In the Edit Series dialog window do the following. Now enter a value 100 for Jan in Ver Line column. To add a horizontal line to your chart do the following.

There are spaces for series name and Y values. Add the date with the current date to your data for example. Notice that the range that is selected only includes the original 12 months.

Eg this will be useful to show data and highlight a current date. Convert Numbers and Currencies to English Words. As before click Add and the Edit Series dialog pops up.

Copy the data select the chart and Paste Special to add the data as a new series. Here you have a data table with monthly sales quantity and you need to create a line chart and insert a vertical line in it. In the next section we are going to format the graph to make it look professional.