Linear gauge chart in Straight table

[sampada0810]

I want to achieve a linear gauge chart in a straight table.

please find the image below:

here the blue bar shows the actual and the needle shows the target.

I tried doing this , but I am getting this:

the actual value is filled up to the end. Please help!!

[vishsaggi]

Can you send snapshot of your Guage setting properties ? or a sample to look into please?

[sampada0810]

consider the following example.

actual is coming same for all products, but it is not.

Please refer attached .qvw and the data sheet.

[sampada0810 · Accepted solution]

I have achieved this by overlapping 2 graphs, one with needle and the other one with the bar and used the property of transparency