Hi Experts,
I'm looking for help on this:
I have a table that contains following data fields (divided by |):
Date | 1 day | 2 days | 3 days | ... ...| 30 days | more than 30 days
e.g 01/02/09 3 0 0 1 2
I need to come up with a chart (see attached) based on data from this table. E.g. a sum of numbers for Feb-09 will be calculated for each bracket of days. However, I want to build in the feature such that user could choose the brackets (i.e. it could be 1-3 days or 1-5 days, so on). And also the months (i.e. jan-09, may09, so on).
Hope the sample is self-explanatory. I don't need the format to be exactly the same. But it's important to capture the essential figures in a presentable way.
Can anyone tell me how to do it, maybe using a form for user input, a query to do the sum and a pivot chart to display the figures?
sample.xls