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

i downloaded a plug in and it does not show up in the ribbon 2
charts look different if you put in data into the x axis 3
autofilter 4
Conditional Formatting 0
Disappearing chart legend 2
Line chart - Change the Axis round 1
Gannt chart: formulas and conditional formatting 3
Ever changing averages, depending on date. 2

Top