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

M

marian

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
 
J

Jon Peltier

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
 
M

marian

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Y-axis values correspond to x- axis value 1
Use text descriptors as Y axis units 1
Chart x axis problem 1
Line Chart - Problems with labeling X-Axis 3
One extra x axis item that wont go away - can anyone help? 3
How do I specify X,Y axis and Series values in a line graph? 5
Reverse y-axis, with maximum number at x-axis 1
Excel 2007: X-axis labeling 1

Top