ConstructionExcelGuy
New Member
- Joined
- Oct 9, 2013
- Messages
- 1
Backstory: So I was assigned a project that requires me to graph (chart) values (y-axis) against time (x-axis). For each row there is a "budget", "spent", and "earned" value (easy enough so far). I put together a pretty slick "running total in" pivot chart that was slice-able by any number of criteria and everyone was happy. Then it was decided that those values in each row needed to be "claimed" on their specific date instead of against the "budget" date.
Excel speak: I now have three individual data series with independent x and y coordinates for each row in my table. I need to be able to graph these as a running total line graph, preferably in a pivot chart as to keep all of the "smart data" intact (there are about 12 filters attached to these data points). The only solution I have has me running everything through a secondary table that uses "sumif" with the dates as a column and searching the first table for the values. This loses the "smart data". Here is a dummy set of the data that is quite slimmed down:
<tbody>
</tbody>
Not as important: Ultimately, this data set is claimed in 5 different stages for each line item (20% of the total value each) with each having an individual date. That creates 15 individual data points that need to be graphed into the three categories (budget, earned and spent) in a running total fashion. I am in the process of learning Powerpivot but am not as good with VBA. I am running Excel 2010 for what its worth.
Any help is appreciated.
Excel speak: I now have three individual data series with independent x and y coordinates for each row in my table. I need to be able to graph these as a running total line graph, preferably in a pivot chart as to keep all of the "smart data" intact (there are about 12 filters attached to these data points). The only solution I have has me running everything through a secondary table that uses "sumif" with the dates as a column and searching the first table for the values. This loses the "smart data". Here is a dummy set of the data that is quite slimmed down:
| Discipline | Work Number | Budget Date | Budget Value | Spent Date | Spent Value |
| A | A-1 | 10/1/13 | 5 | 10/4/13 | 3 |
| A | A-2 | 11/1/13 | 5 | 10/29/13 | 2 |
| A | A-3 | 12/1/13 | 10 | 12/7/13 | 14 |
| B | B-1 | 10/15/13 | 20 | 10/17/13 | 16 |
| B | B-1 | 11/15/13 | 20 | 11/12/13 | 23 |
<tbody>
</tbody>
Not as important: Ultimately, this data set is claimed in 5 different stages for each line item (20% of the total value each) with each having an individual date. That creates 15 individual data points that need to be graphed into the three categories (budget, earned and spent) in a running total fashion. I am in the process of learning Powerpivot but am not as good with VBA. I am running Excel 2010 for what its worth.
Any help is appreciated.
