Hi experts,
May I know how I can create a gauge chart like below? The two needles indicates the values as of 8/31 and 9/28 separately.
Note that there's a black arc which indicates the max value and min value during this period..
The data looks something like below:
Date, Value
8/31, 26000
9/28, 35000
min line value = 25000
max line value = 65000
The lower chart is for another period, so we can see the black arc changes as the min/max line values change.
I understand that the two needles can be created using two gauge charts one on top of another, but not sure how to create that black arc, could anyone help please?