Line Graph in Excel Not Working (3 Examples with Solutions)

Get FREE Advanced Excel Exercises with Solutions!

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.

Line Graph Command Is Producing Two Lines

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.

Line Graph Command Is Producing Two Lines

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


Similar Readings


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.

Gap Appearing in a Line Graph

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.

Gap Appearing in a Line Graph

  • 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.

Gap Appearing in a Line Graph

» 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

Hafiz Islam

Hafiz Islam

Hi there. I am Hafiz, graduated from BUET. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. Now you can see my articles in the ExcelDemy blog.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo