Populate data between Start and End dates in line line chart
I have a programmed activity table where I have a Start and an End date for each activity, each activity have a Volume as other field.
I wuld like to represent in a line chart the total value for each day between the min and max date (01/03/2012 to 09/04/2012). My problem is no the calendar, but to know for example the total value for a specific day. For example, the value for day 07/03/2012 will be 120/10 (10 is the total of days for activity 1) + 245/21 (21 total of days activity 2) wich will give me a total of 27.3125 for that day. As you see, in the original data, I have no data for that specific date.
Example of what I would like to do.
Any help will be very apreciates. Thanks in advance.
Re: Populate data between Start and End dates in line line chart
This is a great solution to my problem. Is there anyway to make the chart display a monthly x axis? I got it working but instead of starting at StartDate the x axis starts at 12/31/1899. Any help would be greatly appreciated.