Forum Discussion
Solved
Number and Goal Visual
Hello - I am working on a table with 2 numbers - the first number is the current score (column A) and the second number is ideal score (column B). I would like to show a graph (similar to the ph...
- no you can't use relative references but you CAN use FIXED numbers so you can set min = 0 and max = 1 and then in K use the formula =G4/I4 (or if that is a table =[Current]/[Desired] or using dynamic arrays =G4:G6/I4:I6)
Then also click "Show Bar Only"
Thanks, mtarler. I tried to go with the option pictured below but I don't think that you can simply copy the conditional formatting and have the reference be the row intended (ideally the last row in the sample which shows current and desired both at 1 would be fully greyed out). Is there a way to do this or would I need to update each individually?
no you can't use relative references but you CAN use FIXED numbers so you can set min = 0 and max = 1 and then in K use the formula =G4/I4 (or if that is a table =[Current]/[Desired] or using dynamic arrays =G4:G6/I4:I6)
Then also click "Show Bar Only"
Then also click "Show Bar Only"
- Thanks! Used the option of [current]/[desired] and created 2 rules.