Help On gauge chart

[suryakant241187]

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

[migueldelval]

Hi Suryakant,

You only need to make calculated colour.

Could you attach a data sample to help you?

Regards

Miguel del Valle

[suryakant241187]

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

[migueldelval]

Hi Suyakant,

Try this example please.

Regards

Miguel del Valle