Hey everyone,

I've been searching for a solution to this for a bit, and maybe I'm just missing something, but I haven't found anything that'll do what I have in mind.

My data looks a little something like this:

2/26/11 - 5
2/27/11 - 6
2/28/11 - 7
4/3/11 - 8
4/4/11 - 9
4/5/11 - 10
etc.

(the "-" signifies a different column)

What I want to do is keep the x-axis smooth and uniform (have the x-axis plot all the dates, even the ones not identified), which is does already, but I don't want Excel to interpolate the values. In other words, when there's a date gap in my data, I want Excel to plot it as exactly that - a gap.

I figured that if it comes down to it, I could write up a code (or find one) to interpolate the dates into the date column from which I'm grabbing the data from, so then it would at least have a zero point to plot, but then I'd fill my data sheet with a whole bunch of blank rows, which I'd like to avoid.

Anyways, any help would be greatly appreciated.

Thanks.
-Reactant
(Excel 2010)