Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have made a gauge chart that I am pretty happy with, but there are a few things I would like to see in this chart that I can't exactly figure out how to make. My Gauge chart right now has the max set to Sales goals and the min set at 0. The needle is set to point at the sum of each months sales then divided by the number of months to average it.
It looks ok, but one thing I have noticed is that sometimes the average sales is higher than the sales goals, but with the max set to sales goals thats where the needle sits. So how do I make it so the max is larger than the sales goal? But I still want to keep sales goal on the gauge as a major unit. And for complete customization I was wondering if there was a way for the point that the needle stops at to become a "unit" and show the number.
Lets say someones Sales goal is $40. I would want the minimum set to 0 as it is and then a maximum larger than $40 and to keep it simple lets say it would be 50, and there are 5 major units that increment by 10. So it would be 0 10 20 30 40 50. If the persons sales averages out to 33 I want it to point to that point but also display the number on the gauge.
One last thing I can't seem to figure out with the gauge chart is how to manually set the size of the segments, I see the check box that automatically sets the size of each segments, but nowhere to manually set them. I have been through the tutorial a few times to see if I missed that but I find nothing.
Thanks for any help, and if there is anything I can clear up I will try and post it.
Hi there
On the max value. The simplest answer is to add a buffer on top of your goal amount. I tend to add between 10 and 50% buffer depending on how unpredictable the data.is.
There is no setting to show the value on the tip of the needle. The options are to hover over the gauge. I tend to have another text box over the guage showing the actual value below (or in the middle) of the gauge.
The last thing is on how to set segment size. Youu have already spotted the autowidth segments flag. Once that is turned off you should notice that in the top-right a field called 'lower bound' becomes active. This is how you set the lower end of each segment. So in your case you would have to segments. Segment 1 would have a lower bound of zero and segment 2 would have a lower bound of your sales goal.
Hope that helps.
Hi there
On the max value. The simplest answer is to add a buffer on top of your goal amount. I tend to add between 10 and 50% buffer depending on how unpredictable the data.is.
There is no setting to show the value on the tip of the needle. The options are to hover over the gauge. I tend to have another text box over the guage showing the actual value below (or in the middle) of the gauge.
The last thing is on how to set segment size. Youu have already spotted the autowidth segments flag. Once that is turned off you should notice that in the top-right a field called 'lower bound' becomes active. This is how you set the lower end of each segment. So in your case you would have to segments. Segment 1 would have a lower bound of zero and segment 2 would have a lower bound of your sales goal.
Hope that helps.
That answers everything I asked! Thanks for the help, was able to find the exact size buffer I needed. Was also able to set the segment sizes, didn't even see that became enabled. Thank you for your help
No problem. Please mark my answer as correct