Forum Discussion
Visualization of Cell values
Anonymous example attached, you can change as per your need.
Anonymous you have to use filter to narrow down the dataset to required value.
If you can post example data with expected result, it will help to provide the answer.
THanks alot. Please look at the followig picture. The vaues in the rows are a result of complex working done on other sheets. I want to display the progress on a gauge.
Anonymous what are the values for the gauge? What represent the target for the gauge and what represent the acutal?
There will be two gauges. One gauge will show the current progress while the other will show the on hold. FOr both the gauges the maximum would be the row2 i.e 125. And the current/actual value for each gauge will be the values in row 3 and 4.