I would like to create a gauge (tachometer) chart in which a needle is shown for each expression. Is this possible?
I know that I can group the different expressions and select each expression by clicking the circled arrow. But I would like to the all (in my case 3) needles at the same time with different colors and a legend.
I hope that you are able to help me, thanks a lot in advance.
In a nutshell, this guage chart "fakes" the needles by using black dummy segments to mimick the needles. There are 4 variables, 3 that define the values of the "needles" and one to show where the limit needs to go (vBoundary)
In the chart presentation tab, I have removed the indicator and unchecked the box marked "autowidth segments", enabling me to edit where the segments start and end.
The 9 segment boundaries are defined as this:
Segment 0 - Lower bound = 0 , colour green
Segment 1 - lower bound - minimum of the vBoundary, and the 3 expression variables. Colour is black (needle colour)
Segment 1a - lower bound - same as segment 1 if this is equal to the vBoundary. Otherwise it is set at vBoundary + 0.05 (width of needle). The colour of the segment is dependant on where the boundary is
.
.
.
.
And so each of the pairs of segments follows a different pattern till Segment 4 and Segment 4a. Took me a while to get me head around it.
