Excel users out there

I know there have got to be some Excel guru's out there that can help me with an issue I am having. If I am making a bar chart using information for the years 2000-2006 but have actual numbers for every other year, is there a way I can come up with a trend line on the graph without the trend taking into account every other year that is zero?

I can pm back and forth with someone too so I don't take up valuable CF time when our first football game is so close and all. I will be in and out watching kids until I put them to bed so if someone answers I will be back.

sorry in advance..:mask:

Take out the zeors and leave the cells blank.

Yeah, I think leaving the cells blank will work. If you can't get it, PM me and I'll have ya e-mail it to me - easier to fix and then instruct from there.