Sometimes you may face that **creation of a line graph in Excel** is not working properly. When creating a Line chart in Microsoft Excel, the chart may show two lines at a time, contain a gap in a line, or the line may not be visible on the chart. In this article, you will learn how to solve all these.

## Download Practice Workbook

You can download the following practice workbook that we have used to prepare this article

## 3 Examples of â€śLine Graph in Excel Not Workingâ€ť Issue with Solutions

### Problem 1: Line Graph Command Is Producing Two Lines

In the case of showing two lines in a chart, you need to convert one series of data (in this example, Year) into text format. Look at the following image. We have plotted this chart for showing different sales in different years. Inserting a line chart, we get the two lines in the chart.

Our goal is to omit the Year line from the chart.

**Solution:**

- For this, we need to convert the Year data into text format. We can simply do this by selecting data and putting
**Apostrophe**in front of it as shown in the image below.

- Next, you need to drag the
**Fill Handle**to the remaining cells to convert all the Year data into text format.

Here is the Year data converted to text data.

- Now, insert the double-line chart again. At this time, you will see the one line that is the Sales line.

**Read More:**** How to Make a Line Graph in Excel with Multiple Lines (4 Easy Ways)**

**Similar Readings**

**How to Add a Vertical Dotted Line in Excel Graph (3 Easy Methods)****Make Line Graph in Excel with 2 Variables (With Quick Steps)****How to Draw Target Line in Excel Graph (with Easy Steps)****Draw a Horizontal Line in Excel Graph (2 Easy Ways)**

### Problem 2: Gap Appearing in a Line Graph

An Excel line chart may contain a gap in the line when you create it. There is a possibility that this issue will occur if there is a blank cell in the data range for the Line chart.

**Solution:**

Here is a solution you can use to overcome this issue.

Display empty cells based on interpolation. For that, just do the following.

**Â» In Excel 2007 and Higher Versions:**

**Right-click**anywhere within the chart after selecting the chart. Then, click on**Select Data.**A**Select Data Source**dialog box will pop up.

- You can then select
**Hidden and Empty Cells.**A**Hidden and Empty Cells Settings**dialog box will appear.

- Choose the
**â€śConnect data points with lineâ€ť**option, then press**OK**twice.

Finally, here is the result.

**Â» Excel 2000-2003:**

- To begin, click your Line chart.
- Click
**Options**from the**Tools**menu. - Select Interpolated from the
**Chart**tab, then click**OK.**

**Read More:** **How to Make a Double Line Graph in Excel (3 Easy Ways)**

### Problem 3: Line Not Visible on Chart

Consider a chart with year on **X**-axis and COMBO **Y** axis in which data is displayed as four series (three lines on the left Y axis and one bar graph on the right **Y** axis). The lines are all good except for one that isnâ€™t visible. There is a legend for the missing line, but not the actual data line, showing up as part of the data series. You may have tried selecting data/hiding cells/connecting data points with lines, but are not able to get the last data to appear. There is a solution for you discussed below.

**Solution:**

After selecting the chart, the **Chart Tools** group appears on the right-hand side of the Ribbon, including the **Design and Format** tabs. In the Format tab, you can select different elements of the chart using a dropdown menu on the left. You should see little handles where the points should be if you select a series you cannot see.

**Read More:** **Sparklines in Excel (Insert, Change, & Modify to Show Data Trends)!**

## Conclusion

In this tutorial, I have discussed 3 examples with solutions about line graphs in Excel not working. I hope you found this article helpful. You can visit our website **ExcelDemy** to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.

**Related Articles**

**How to Add Vertical Line in Excel Graph (6 Suitable Examples)****Combine Bar and Line Graph in Excel (2 Suitable Ways)****How to Make a Line Graph in Excel with Two Sets of Data****Make Line Graph with 3 Variables in Excel (with Detailed Steps)****How to Overlay Line Graphs in Excel (3 Suitable Examples)****How to Make a Line Graph in Excel with Multiple Variables**