Hello,
I want to create a burndown chart for a specific activity. Say I have 5 departments (A, B, C, D and E), each of them with 10 activities (1, 2, 3, 4, 5, 6, 7, 8, 9 and 10). Each combination of Department/Activity will be finished in a certain date.
I have a "raw data" table with each activity ID and its closure date. I created a Pivot Table to make it easier.
This Pivot Table displays the Departments in the rows/lines and each closure date on the columns.
How do I extract the information from the headers of the columns (each date) and the footer/bottom of the table (the grand total for each column/date)? Is it possible to add those extracted data in a new Pivot Chart?
I would like to make it in a way that if more different dates are added, i.e. thus more columns are added, it gets reflected as well.
Then, since it's a burndown and I have the total pending, I would need to plot the balance of the Planned and the Actual for each day.
To illustrate:
- Two Pivot Tables with Planned / Actual Closure Date, extracted directly from the Raw Data:
- Planned Closure Date (manually extracted from the Pivot Table):
- Actual Closure Date (manually extracted from the Pivot Table):
- What I then manually did: two tables with the Balance of Planned and of the Actual, i.e. the total of actions (164) minus the planned and the actual for each day:
- And then I finally plot both Balance curves, which gives me the burndown.
Even though I'm struggling to figure it out a way to do that, it doesn't seem to be that complicated. Could someone please shed some light?
Thank you very much,
Caio
I want to create a burndown chart for a specific activity. Say I have 5 departments (A, B, C, D and E), each of them with 10 activities (1, 2, 3, 4, 5, 6, 7, 8, 9 and 10). Each combination of Department/Activity will be finished in a certain date.
I have a "raw data" table with each activity ID and its closure date. I created a Pivot Table to make it easier.
This Pivot Table displays the Departments in the rows/lines and each closure date on the columns.
How do I extract the information from the headers of the columns (each date) and the footer/bottom of the table (the grand total for each column/date)? Is it possible to add those extracted data in a new Pivot Chart?
I would like to make it in a way that if more different dates are added, i.e. thus more columns are added, it gets reflected as well.
Then, since it's a burndown and I have the total pending, I would need to plot the balance of the Planned and the Actual for each day.
To illustrate:
- Two Pivot Tables with Planned / Actual Closure Date, extracted directly from the Raw Data:
- Planned Closure Date (manually extracted from the Pivot Table):
- Actual Closure Date (manually extracted from the Pivot Table):
- What I then manually did: two tables with the Balance of Planned and of the Actual, i.e. the total of actions (164) minus the planned and the actual for each day:
- And then I finally plot both Balance curves, which gives me the burndown.
Even though I'm struggling to figure it out a way to do that, it doesn't seem to be that complicated. Could someone please shed some light?
Thank you very much,
Caio
