Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have 1 gauge chart, but color of gauge chart needs to be change according to condition. for e.g. if any employee has completed timecards for 13 weeks i.e. for 1st quarter the it should be green. if anyone has filled but not for all 13 weeks then it should be yellow and for 0 time card filled it should be Red.
attached is the gauge chart.
Regards,
Suryakant
Hi Suryakant,
You only need to make calculated colour.
Could you attach a data sample to help you?
Regards
Miguel del Valle
Hi,
data will be number of weeks employee has filled the timecard. for e.g 12 weeks, 11 weeks.
Emp No. Timecard Filled
101 13
102 0
103 8
For emp no. 101 it should be green , for emp no. 102 it should be Red and for emp no 103 it should be yellow.
Regards,
Suryakant
Hi Suyakant,
Try this example please.
Regards
Miguel del Valle