Charting missing date values on constant x-axis
Posted on 1997-10-14
I have some dates with some number values, but the dates have gaps in between. For example, January (130) March (250)
How can I plot a graph which plots EVERY subsequent date from the first date to the last? In the above example, missed months like February would have a value of nothing or 0.
I'm using Access95. I know Excel can recognise dates on the x-axis and it knows to plot all the dates, but Excel is not an option here.