Excel Speed-o-meter - Needle incorrect value

[tomass1984]

HI,

I am wondering if somene could assist as I can't seem to work this out, I have created the following speedometer chart -

As you can see the needle should be pointing at 100, however, it sits at 78 ish

I have configured using these tables -

Performance Label	Value		Labels	Values		Labels	Values
Poor	25		10	10		Pointer	100
OK	45		20	10		Thickness	1
Good	15		30	10		Rest	154
Excellent	15		40	10
Total	100		50	10
			60	10
			70	10
			80	10
			90	10
			100	10
			Total	100

If I change the input to 50 -

It sits just below where it should so the data isnt being represented accurately, has anyone ever seen this issue before or know how to solve it? Ive created a couple both slightly different styles, but the same issue

Many thank in advance

 

[dmt32]

Hi,
I guess you created this following Excel Champs How to Create a SPEEDOMETER Chart [Gauge] in Excel [Simple Steps]

If so, suggest that you download the completed sample file here: Speedometer Sample File

and use as a comparison to check each of your chart settings or just use it in your project

Hope Helpful

Dave

 

[tomass1984]

Thank you as pee usual i skipped a step

 

[dmt32]

Thank you as pee usual i skipped a step

most welcome
As tip for future, always helpful to the forum if you reference the source of origin (and a courtesy to the author) when using ideas posted on other sites. Doing so makes it a little easier to fully understand any issues

Dave