cannot connect the dots in chart

K

kyle

i'm making a chart with 3 columns of data. in one column every cell is
filled. there are about 400 cells. in the next column not every cell is
filled, maybe about 20, same as the third column. when i make a chart i
cannot get a line to connet the data in column two and three. worse, i
cannot get a trendline to apply. i'm trying to get a 5 period moving average
or so for column two and three and i can't. here's a picture so that you
know what i'm talking about.

http://i87.photobucket.com/albums/k137/kylefoley76/Picture2-2.png


Picture2-2.png
 

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

charts look different if you put in data into the x axis 3
i downloaded a plug in and it does not show up in the ribbon 2
autofilter 4
Some chart types cannot be combined... 1
Gannt chart: formulas and conditional formatting 3
Line chart - Change the Axis round 1
how to get values in between data? 5
how to show the total in a pivot chart 1

Top