Indicator in speedometer chart

[wrybel]

Hi everyone,

I will be grateful for help in constructing an indicator in speedometer chart which need to be narrow at the and and wide at the base (like in attached spreadsheet).

Thanks in advance !

[Glenn Kennedy]

I don't understand your request. You have an example in your attachment. Can you not adapt your data to fit it? What data do you want to plot? Can you attach an Excel copy of your data, explaining how it is to be treated?

[Andy Pope]

@Glenn, the example uses 2 charts. In order to update the point you also need to reposition the chart object.

Instead add a xy-scatter series to draw the pointer. If you want the needle to be filled you will need to add some more data points that go from center to outer point.

[wrybel]

Thanks a lot again Andy. Perfect solution !!!