Thread: Line chart with missing data

Hi,

I am sure this is basic but I have been unable to work it out, I have a table (date, spend 1,spend2,spend3). the date column has all the days in a month and then each spend column will have around 10 entries through out the month at diffrent times.

I want the line graph basicly just to join the dot's but i can not do it.

Thanks

Ed

type #N/A into the cells you do not want plotted and excel will ignore them and only join the cells where there is a number