Why is my 3rd x axis values only showing the bullets & not line?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 3 values for my x axis. With each value I have chosen the line graph.
My 3rd value only shows the bullets and not the line. I have tried changing
the color but that doesn't work. My first 2 lines are correct. Can't find
where I am doing something wrong
 
Are there gaps in the data? If so, select the chart, go to Tools menu >
Options > Chart, and in the top section, choose the option to interpolate
over blank cells.

- Jon
 
That did it!! Thank you very much!!

Jon Peltier said:
Are there gaps in the data? If so, select the chart, go to Tools menu >
Options > Chart, and in the top section, choose the option to interpolate
over blank cells.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
Click to expand...
 
Back
Top