Line not visible on chart

[QDavis]

I have a chart that has year on the X axis and a COMBO Y axis, which should display 4 series of data (three lines on left Y axis and 1 bar graph on right Y axis). All are good except that one of the lines i snot visible. The data shows up as being part of the data series and the legend for the missing line is present, just not the actual line of data. I have tried to do: 'Select Data/ Hidden and Empty Cells/ Connect data points with line' but can't get the last data to show up. Anyone know how I can fix it? Thank you!

 

[RoryA]

If you select it using the dropdown on the left of the Format tab in the Chart group, can you see the selection indicators on the chart? Is it perhaps either formatted with no line, or behind another series, or plotting on the wrong axis?

 

[QDavis]

If you select it using the dropdown on the left of the Format tab in the Chart group, can you see the selection indicators on the chart? Is it perhaps either formatted with no line, or behind another series, or plotting on the wrong axis?

I'm afraid I'm not following you. Sorry. :/ Can you try again? Thanks!

 

[RoryA]

First change the axis on the right to start at 0, and see if you can then see the line. If so, it's just plotted on the wrong axis.

 

[QDavis]

I changed the axis minimum to 0 - a good idea anyway, but it still is not showing up. Don't know if this is helpful, but when I change the order of the legend entries in the Select Data text box, that shifts which 2 lines (of the three) show up.

 

[RoryA]

If you select the chart, you should see the Chart Tools group appear at the right hand side of the Ribbon, with Design and Format tabs available. If you select the Format tab, on the left there is a dropdown that allows you to select different elements of the chart. If you select the series you can't see, do you see little handles appear where the points should be - see picture below with the relevant items highlighted:

 

[QDavis]

Oh my good ness. Thank you! That was it - well, that allowed me to see that I had the same data in twice for two variables so I could not see any difference.
Corrected the data and now it shows up. THANK YOU!!!.

 

[RoryA]

Glad we could help sort it out.