There Are Gaps Between Dates Plotted In. How to fill a gap in dates in a excel table dates in the first column and data in the second t Jean-Pierre Fruchet As variant you may add another calendar column from minimum date to maximum or newer eg. There are gaps between the dates plotted in my chart.
If I have a record that goes from 2003-2004 assume a month and date then has a gap of 8 months and picks up again with 2005 to 2006 and 2006 to EndDt IS NULL for still there. She used to take them once a month but now its every 15 days. Start with your monthly data in A1B5.
SELECT FROM SELECT C D LEADB OVER ORDER BY B E FROM T WHERE D E.
Also it should be noted that the same id can have undetermined number of observations and they might not be in a particular order. She used to take them once a month but now its every 15 days. How to calculate the number of months between two dates in Excel. After applying these settings your graph will.