+ Reply to Thread
Results 1 to 1 of 1

need to create process bar with different critera

  1. #1
    Registered User
    Join Date
    11-19-2014
    Location
    colorado
    MS-Off Ver
    excel 2k13
    Posts
    14

    need to create process bar with different critera

    Hi,
    I'm working with a client to create a dashboard. They want a timeline progress bar with milestones and the ability to drill down and see what task are not complete causing the milestone not to go to 100%. I tried to go the simple route with slicers but the wont a progress bar with milestone that are clickable. Attached is the spreadsheet data is under the data tab. Any ideas or suggestions would be greatly appreciated.

    example:

    model
    progress bar
    296 ------------------------------------------------------
    milestone1 milestone2 milestone3
    click on milestones and task belonging to milestone appear.
    ------------------------------------------------------


    progress bar
    249 ------------------------------------------------------
    milestone1 milestone2 mileston3
    click on milestones and task belonging to mileston appear.
    ------------------------------------------------------
    Attached Files Attached Files

+ 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. [SOLVED] create and process dynamic form
    By HarryKlein in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-09-2014, 06:27 AM
  2. VBA to create specific named ranges and repeating process (Loop?) across columns
    By vinothj86 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-30-2012, 05:01 AM
  3. Replies: 4
    Last Post: 06-23-2009, 09:57 PM
  4. Replies: 2
    Last Post: 07-10-2005, 03:05 PM
  5. [SOLVED] How to count process running time ( process not finished)
    By miao jie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2005, 02:06 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