+ Reply to Thread
Results 1 to 3 of 3

Like Gant Chart But With Dollars?

  1. #1
    Registered User
    Join Date
    01-14-2011
    Location
    colbert, washington
    MS-Off Ver
    Excel 2003
    Posts
    2

    Like Gant Chart But With Dollars?

    Good morning,

    I have several hundred savings projects I work on and I have been tasked with tracking the the estimated savings against the actual savings each month. What they want to see is something like a gantt chart but instead of being date based it needs to be $$ based. Can anyone help?

    Thanks,

    Laura

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Like Gant Chart But With Dollars?

    Help with what exactly.

    I assume you have looked at the gantt chart examples and understand the technique used to construct the 'floating bar'. In which case you just need to do the same with your data.

    Or maybe the problem is a gantt chart does not actually make sense in terms of dollars. Why not simple have 2 series 1 for Estimate and one for actual.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-14-2011
    Location
    colbert, washington
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Like Gant Chart But With Dollars?

    Thanks....I was able to fix it to represent it the way I needed.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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