Line Graph

M

Mike

In Excel 2000, how do I connect points in a line graph if I am missing
intervening data. For example if the x axis is 1,2,3,4,5,6 and I have data
at only 1,3,5,6, how do I connect these points.
Thanks
 
S

Shane Devenshire

Hi,

With the chart selected choose Tools, Options, Chart and set Plot empty
cells as to Interpolated.
 

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

Graph Line Width ? 1
How can I make a scatter plot graph with a category x-axis? 0
Chart with differing x axis 1
My data points disappear 3
Move Data Series Manually 4
connect line to data points with missing data in between 3
graphing numerical values on the x-axis 2
Plot value at top of chart 1

Top