+ Reply to Thread
Results 1 to 3 of 3

Project/Milestone Chart - Need Suggestions for Displaying Status

  1. #1
    Registered User
    Join Date
    12-17-2019
    Location
    Salem, OR
    MS-Off Ver
    Office 365
    Posts
    4

    Project/Milestone Chart - Need Suggestions for Displaying Status

    I finally got my chart in Excel working the way I want it. Two of the major hurdles that I finally overcame were:
    • Show the start and end dates for the entire project as well as each milestone (in the axis). The range displayed needs to change automatically based on which project is selected.
    • Display a line indicating today's date.

    Now, what I am trying to figure out how to accomplish is "How do I get my status' into the chart?" - Not started, Work In Progress, Completed, etc.,.

    I personally thought the best way to do that would be to utilize VBA code to change the color of the bar based on the status in my status column. I could then easily make a legend at the bottom of my chart (manually) indicating what each color represented. I haven't found anything that seems to do what I am after.

    As a last resort, I could simply concatenate the values from my status column into the title column. But, that would be quite boring.

    Does anyone have any suggestions on how I can achieve what I am after? I am wanting to either 1.) Have the bar color change based on the status or 2.) Incorporate the actual status somewhere into the chart. I'm open to suggestions. I'm not open to re-creating this monstrosity from scratch! Yes, I know it's probably the worst thing you've ever seen!

    I am attaching a copy of what I'm working with. I will apologize in advance for the use of dummy data and dates that don't make any sense!

    NOTE: The purpose of this is to be used for creating a project status presentation for my leadership team. Hence the filename.
    Attached Files Attached Files

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

    Re: Project/Milestone Chart - Need Suggestions for Displaying Status

    Add an extra series for each planning stage. Use formula to control the value for each of the series with only the matching stage series having a value.
    The new chart data is to the right of you current table.

    I have also tweaked the worksheet change code so it does not select the chart everytime you enter values on the sheet.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    12-17-2019
    Location
    Salem, OR
    MS-Off Ver
    Office 365
    Posts
    4

    Re: Project/Milestone Chart - Need Suggestions for Displaying Status

    Awesome! Thank you for the suggestion and fix to the worksheet change. That was annoying me!

+ 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. High Level Project Milestone Tracker
    By morerockin in forum Excel General
    Replies: 3
    Last Post: 04-07-2018, 12:53 AM
  2. project status chart (PDR, CDR..) planned vs actual.
    By gefmos in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-24-2017, 08:50 AM
  3. Milestone RAG status Current vs Prev Trend Chart
    By ramgouda in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-26-2015, 04:28 PM
  4. Create a milestone workbook with Gantt Chart and RAG status and publish in powerpoint
    By parineetat in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-30-2014, 05:51 AM
  5. Gantt Chart -Conditional Formatting for project status
    By llattrell in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-30-2013, 05:00 PM
  6. suggestions on hiring someone to do a project.
    By mt45 in forum Excel General
    Replies: 1
    Last Post: 08-02-2011, 06:54 PM
  7. Suggestions for a project (newbie)
    By Dormage in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-30-2010, 09:42 AM

Tags for this Thread

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