+ Reply to Thread
Results 1 to 2 of 2

Gantt chart and budget in one graph

  1. #1
    Registered User
    Join Date
    06-30-2014
    Location
    Chicago, IL
    MS-Off Ver
    2010
    Posts
    2

    Gantt chart and budget in one graph

    I want to create a bar graph that shows the timeline of 3 phases on the x-axis and budget/month on the y-axis. The projects will stack up. How do I go about creating this graph, and how do I display the project name in each bar? Attached files are a sample data as well as rough drawing of how I want the graph to look like. Any help is greatly appreciated!Volume of Work Sample Graph.pngVolume of Work Sample.xlsx
    Last edited by hue2; 06-30-2014 at 01:15 PM.

  2. #2
    Registered User
    Join Date
    06-30-2014
    Location
    Chicago, IL
    MS-Off Ver
    2010
    Posts
    2

    Re: Gantt chart and budget in one graph

    Volume of Work Sample Graph 2.pngThis graph might make more sense to see the total budget for all projects for each month, but I don't know if it is possible to create a graph like this on Excel.

+ 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. Replies: 5
    Last Post: 10-04-2012, 07:01 AM
  2. Replies: 0
    Last Post: 07-13-2012, 06:40 PM
  3. Bar Graph/Gantt Chart
    By BobSmith9 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-07-2012, 06:44 PM
  4. Weekly Time based Gantt Graph
    By Jubez in forum Excel General
    Replies: 0
    Last Post: 06-15-2011, 08:29 AM
  5. row data too large - cannot graph gantt chart
    By Aussie1497 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-02-2005, 04:47 PM

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