I have data with task Start and End Dates that I need to display in a bar
chart. I am having difficulties as some of the Start date could begin in Jan,
but end in Mar, Some begin in Jan and end in Jul, What I need is for the
pivot table to create a chart that shows in Jan there are 'X' number of
tasks, this should follow through until Mar, for the first then Jul for the
next example, but it doesn't.
What I get instead is 2 tasks in Jan, then none for the rest of the year.
Grouping doesn't work as I need to see every month and every task. i.e. Task
1 should appear on the chart for Jan, Feb and Mar.