Hi All,
I have been looking for a % Progress Bar that will run automatically in a cell and there are many examples but not one like I would like it to feature.
The sample attached is an idea of what I am looking to achieve
Thanks in advance for any ideas to make this happen
Sample.xlsx
John
Last edited by JJFletcher; 02-06-2016 at 02:38 PM.
Use conditional formatting -- Data Bars
See attached
Last edited by Ace_XL; 02-06-2016 at 10:35 AM. Reason: Edited attachment
Life's a spreadsheet, Excel!
Say thanks, Click *
Hi Ace_XL,
Thanks for your reply... I have seen examples of this % Bar - But can this be achieved in the Cell C35 of your example next to - % Complete _________
Thanks in advance
John
When I enter the =C30 parameter the number shows up - not the bar!
The same CF rule needs to be applied to Cell C35.
Then, make sure in the CF rule you have the 'Show Bar only' box checked.
Just delete the CF rule from Cell C30
Last edited by Ace_XL; 02-06-2016 at 10:18 AM.
Ace,
That is AWESOME - It worked... Is there a way to not show the Bar in C30 - seems silly to have two progress bars, and is there a way that the bar actually shows the % of completion?
I am not seeing any changes to the example you edited!
Ok - So you just removed the Conditional Formatting from C30.. Can the Conditional Formatting allow for the numbers of % to be viewable as it changes - IE 5% then 10% then so on and so on
Is it even possible for the Conditional Formatting to show the % as it changes?
Why not simply have that in the adjoining cell by way of a simple formula?
In D35 use
=C30/C4
Format as %
ACE,
That is an excellent suggestion... Thanks for all your help - All looks great and works!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks