+ Reply to Thread
Results 1 to 4 of 4

Progressbar showing 100% as halfway finished

  1. #1
    Registered User
    Join Date
    03-18-2019
    Location
    DK
    MS-Off Ver
    365
    Posts
    2

    Progressbar showing 100% as halfway finished

    My progress bar (created using conditional formatting) looks weird.

    Some cells shows 100% as half the cell width and som as the complete width. Can anyone help?
    (see pictures below)

    Excel01.PNG
    Excel02.PNG

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

    Re: Progressbar showing 100% as halfway finished

    As you only posted pictures we can not tell but are all the cells based on the same data range?
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,489

    Re: Progressbar showing 100% as halfway finished

    Databar CF will evaluate values in relation to eachother so if all cells are 100% it will fill half when you set percent.
    Instead of choosing percent choose automatic
    OR choose number and fill 0 as minimum and 1 (=100%) as maximum. that way your bars will show correct fill

    I cant remember exact explanation why percent does not work but it has to do with how excel evaluates the applied range when you choose percent it will compare each score with eachother and that causes excel to see 100% as only half filled when there are only 100% values, you can check by putting 0% (or any other then percentage) in 1 of the cells in the CF applied range. then 100% bars will show ok.
    so normally when even 1 cell with a percentage is other then 100% it works but when all values are 100% (which is normally the goal if you are doing percentage completion) it gives the strange bars, but since 110% completed task is not possible (no brownie points for extra effort ) I use the number limit as shown above.
    You cloud also "trick" excel by hiding a 0% value in one of the cells of the applied range than it will also evaluate properly with all 100% scores

    Edit: to clarify based on Andy Pope's comment. I ASSUMED that the first 2 cells that show correct databar are in a different CF-rule.
    I just recognised the problem from one of my sheets where I had a simular issue and above adjustments solved the problem for me.
    Last edited by Roel Jongman; 03-18-2019 at 05:23 AM.

  4. #4
    Registered User
    Join Date
    03-18-2019
    Location
    DK
    MS-Off Ver
    365
    Posts
    2

    Re: Progressbar showing 100% as halfway finished

    Dear all
    I found a solution but I'm not sure I understood how except that it has something to do with data range.

    In the top cell I changed the rule to only count for that cell (it still looked weird after that). Then I deleted all rules for all the other cells except for the top one. Then I changed the data-range on the top one, to include all the cells and then it worked.

+ 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] Moving the columns halfway
    By roskalov in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-07-2017, 02:42 AM
  2. ProgressBar.exe
    By rbirch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-28-2016, 05:24 PM
  3. Creating a chart showing started and finished, per date?
    By jaqob in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-29-2016, 09:03 AM
  4. Help with progressbar
    By Marco-Kun in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-24-2009, 08:20 AM
  5. ProgressBar
    By Progress2007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-09-2008, 03:57 AM
  6. [SOLVED] Macro running halfway only
    By Joe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2006, 01:55 PM
  7. [SOLVED] Progressbar
    By EXCEL NEWS in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-17-2005, 10:05 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