Area Chart without individual data points

[fnzeee]

I have a table of data with the following fields:

Resource Name 1, Start Date 1, End Date 1, % Allocated 1, Resource Name 2, Start Date 2, End Date 2, % Allocated 2, Resource Name 3, Start Date 3, End Date 3, % Allocated 3

From this I am trying to create an area chart that shows the % allocated BY MONTH that a resource is allocated. So the graph would show the % allocated for Resource 1 between resource 1's start and end dates. It would show the same for resource 2 and for resource 3.

The issue is that the chart object expects that each record is a data point. In this case there would be many data points for each record (one for each month that occurs between the start and end date for that resource). I need to build a query or configure the chart object to extrapolate data points (% allocated per month for Resource 1, 2 and 3) to use for the graph. Any suggestions on the best way to accomplish this? Any help is appreciated - I am dead in the water.


Thanks,

Steve