+ Reply to Thread
Results 1 to 4 of 4

Percentage Bars / Progress Trackers

  1. #1
    Registered User
    Join Date
    11-30-2018
    Location
    London
    MS-Off Ver
    Microsoft Office Standard 2013
    Posts
    2

    Percentage Bars / Progress Trackers

    Hello All,

    I am wanting to set up a progress tracker for work.

    See attached.

    when a 'tick' is entered into either of the 3 columns i want a percentage bar to fill accordingly. preferably with a blue bar and the percentage number in the middle of the bar.

    then at the bottom a total bar.

    can anyone help?

    Thanks

    Ben.
    Attached Files Attached Files

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Percentage Bars / Progress Trackers

    see the attached file, Conditional format used
    Attached Files Attached Files
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    11-30-2018
    Location
    London
    MS-Off Ver
    Microsoft Office Standard 2013
    Posts
    2

    Re: Percentage Bars / Progress Trackers

    thank you, very helpful.

    is there a way I can include a drop down menu so I can choose between the 'tick' 'cross' and 'exclamation' mark - so that if there is an exclamation' mark I can write a comment in a comments colomn and so the tick is the only object that changes the percentage.

    right now the cross changes the percentage too.

    thanks.

    Ben.

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

    Re: Percentage Bars / Progress Trackers

    I believe that the attached does what you want.
    1) The formula for F3:F9 has been changed to read: =COUNTIF(C3:E3,">="&2)/3
    2) The formula for F10 has been changed to read: =AVERAGE(F3:F9)
    3) In conditional formatting the rule for the exclamation mark has been changed from percent to number.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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: 7
    Last Post: 10-20-2015, 01:51 PM
  2. Progress bars for production lines
    By rosshkerr in forum Excel General
    Replies: 1
    Last Post: 05-19-2015, 12:28 AM
  3. [SOLVED] Progress percentage function for student's grades
    By ckonsta in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-20-2013, 02:17 AM
  4. Progress Bars
    By kempyboffin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-28-2013, 02:37 AM
  5. percentage progress bar in vba
    By djwaz69 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2013, 10:34 PM
  6. Progress Bars, Optimization, Time Study
    By msanford88 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-15-2012, 12:48 PM
  7. Progress Bars
    By Information Hog in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2005, 06:51 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