I suggest you read any book by Stephen Few before you try to go down that path.
Hey dahl can u suggest any other chart that can be used to show performance as suh
A bullet chart is much more effective and uses less real estate. If your client insists (and cannot be educated), one option is to use an embedded Google chart on a dashboard, with the values being fed from Tableau. See here. https://groups.google.com/forum/?fromgroups=#!topic/google-chart-api/ShuDqOc3NJs
I would first suggest though that it really cannot be done - be prepared to show why a bullet chart is better.
I need Gauge chart in tableau. Suppose if I have a value say [Profit %]=33 then my chart should range between -500 to 500. That is percentage would vary between -500 to +500. Using the value 33 i need to find x and y coordinates. How do I achieve this. Basically the coordinates are identified dynamically.
Also if possible -500 and 500 extreme values can be dynamic.