use data bar based on value in another cell

[eddy.bouza]

im trying to use the data in the second column to show progress on close out of the issues in the first column; im having trouble 1) pointing to the number in the other cell to use as the data value and 2)each data bars' maximum could be unique will be different based on the reported amount, is there a way to do this using formulas?

Capture.PNG

[GeoffW283]

If I'm understanding you correctly you want data bars to graphically show the progress of issue closure. Correct?

I chose to add a 3rd column that shows % complete for each row then added the formula =B2/C2 to C2 and copied down.

To apply the data bars, first select the cells of interest, in this case C2:C4 then Conditional formatting > Data bars > More Rules. You should see something like the following:

databars2.png

I changed Minimum Type to Number and a Value of 0 then Maximum Type to Number and a Value of 1. Those are the only changes I made from the defaults.

You should now have something like:

databars1.png

Is this along the lines of what you were looking for?

[eddy.bouza]

Crafty solution, thanks! Yea I’m thinking this is the way, I was trying to show the data bar in the same cell that has the total issues but that seems superfluous after seeing your solution, cheers!

If I'm understanding you correctly you want data bars to graphically show the progress of issue closure. Correct?

I chose to add a 3rd column that shows % complete for each row then added the formula =B2/C2 to C2 and copied down.

To apply the data bars, first select the cells of interest, in this case C2:C4 then Conditional formatting > Data bars > More Rules. You should see something like the following:

Attachment 614734

I changed Minimum Type to Number and a Value of 0 then Maximum Type to Number and a Value of 1. Those are the only changes I made from the defaults.

You should now have something like:

Attachment 614733

Is this along the lines of what you were looking for?

[GeoffW283]

Glad to help - thanks for the feedback.

If you’re all set then can you please mark the thread as solved. To do this select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks!

[ksanghera]

GeoffW283; how can we do the same but without the need to introduce Column C. Suppose Column A says Issues Closed, B says Total issues Logged, and I want B to show % complete i.e. A/B bar to display in column B itself?