+ Reply to Thread
Results 1 to 4 of 4

Pivot Chart: Task spend over time, +comparison w/ Task Budget

  1. #1
    Registered User
    Join Date
    08-28-2017
    Location
    United Kingdom
    MS-Off Ver
    2016
    Posts
    40

    Pivot Chart: Task spend over time, +comparison w/ Task Budget

    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
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,535

    Re: Pivot Chart: Task spend over time, +comparison w/ Task Budget

    Perhaps this "Multiple Time Series" article by Peltiertech may provide some help. I realize that the article displays two line graphs, however perhaps by changing the 'weekly' line into a column chart you could achieve the effect you want.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    08-28-2017
    Location
    United Kingdom
    MS-Off Ver
    2016
    Posts
    40

    Re: Pivot Chart: Task spend over time, +comparison w/ Task Budget

    Yes! I also added a comment to that article. IT doesn't exactly have the answer to creating an X-axis of Week numbers, but it inspired me with the Dummy series idea. I created a Dummy series of Dates corresponding to the beginning of each week number, and a third column that is formatted "WW-YYYY" (created using a formula). Then the data labels are "Value from Cells" and I select that third column as the range of data labels.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,535

    Re: Pivot Chart: Task spend over time, +comparison w/ Task Budget

    Glad that the article is helpful. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to chart Time of Day vs. # minutes a task takes
    By DocCMO in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-18-2017, 02:13 PM
  2. Replies: 1
    Last Post: 02-15-2017, 11:24 PM
  3. export excel list of task in custom outlook task 2010.
    By maxseal in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2014, 03:51 PM
  4. Need a chart displaying task by time (close to a Gantt)
    By gil_mo in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-28-2013, 01:18 PM
  5. Replies: 0
    Last Post: 11-17-2013, 10:21 AM
  6. [SOLVED] IF contingent task closed, THEN change formatting of dependent task cell
    By tek_9 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-29-2012, 08:40 PM
  7. Budget v Spend Pivot Table - can this be automated?
    By NicNocs in forum Excel General
    Replies: 6
    Last Post: 10-02-2011, 09:18 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1