I am half way to creating my envisioned chart, which I am CERTAIN is a popular type of pivot chart to create -- companies must do this all the time, when they have employees booking time ("Cost Registered") to some Tasks or projects, and they want to monitor the accumulation of time (/money) spent on the project over time ("Sum of Cost Registered" as a "Running total in..." time, e.g. in week numbers). Then they must be interested in knowing the % of the total task or project budget spent.
I've sketched out the Pivot Table and Pivot Chart for this, very succinctly, and attached. I cannot share the original data set. However, I think someone will be able to point me to a helpful walk through / blog that must already exist, to get me through the process... Or you may point to some instructions that tell me a better way to display this information. Therefore, I don't expect anyone needs my Excel spreadsheet, because I'm not expecting you to do any work on a spreadsheet for me
Thanks all
Bookmarks