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

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

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

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
_______


"marian" wrote in message
...
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

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

That did it!! Thank you very much!!

"Jon Peltier" wrote:

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
_______


"marian" wrote in message
...
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