Progress bar percentage excel
tony020422
Posted messages
566
Registration date
Status
Membre
Last intervention
-
FIDEL -
FIDEL -
Good evening everyone,
and my best wishes for 2010 before we start!
As part of my work, I would like to illustrate the progress of a construction site on day J using a pie chart or a horizontal progress bar.
For this, I would like that by entering a value in a cell, for example "60", a progress bar or pie chart automatically appears in the adjacent cell illustrating this 60% (with, for example, red color from 0 to 60 and the rest of the bar in black... and as soon as we reach 100%, the bar or pie chart turns green)..
Is this possible? Could someone please help me?!
Thank you in advance,
Have a good evening!
--
When we see what we see, hear what we hear and know what we know, well, we are indeed right to think what we think......
and my best wishes for 2010 before we start!
As part of my work, I would like to illustrate the progress of a construction site on day J using a pie chart or a horizontal progress bar.
For this, I would like that by entering a value in a cell, for example "60", a progress bar or pie chart automatically appears in the adjacent cell illustrating this 60% (with, for example, red color from 0 to 60 and the rest of the bar in black... and as soon as we reach 100%, the bar or pie chart turns green)..
Is this possible? Could someone please help me?!
Thank you in advance,
Have a good evening!
--
When we see what we see, hear what we hear and know what we know, well, we are indeed right to think what we think......
Configuration: Windows 2003 Internet Explorer 6.0