I need help with Pointer on Speedometer chart. My pointer rotation is set at 270 but its not correct. I tried different value for rotation but its not moving in right direction when i change value. I wish i could load excel file here or email to see what i am doing wrong!
[TABLE="width: 500"]
<tbody>[TR]
[TD]Speedometer data
[/TD]
[TD][/TD]
[TD]Series level
[/TD]
[/TR]
[TR]
[TD]Starting point
[/TD]
[TD][/TD]
[TD]12
[/TD]
[/TR]
[TR]
[TD]range
[/TD]
[TD].5
[/TD]
[TD]12.5 (12+.5)
[/TD]
[/TR]
[TR]
[TD]range
[/TD]
[TD].5
[/TD]
[TD]13
[/TD]
[/TR]
[TR]
[TD]range
[/TD]
[TD].5
[/TD]
[TD]13.5
[/TD]
[/TR]
[TR]
[TD]range
[/TD]
[TD].5
[/TD]
[TD]14
[/TD]
[/TR]
[TR]
[TD]range
[/TD]
[TD].5
[/TD]
[TD]14.5
[/TD]
[/TR]
[TR]
[TD]range
[/TD]
[TD].5
[/TD]
[TD]15
[/TD]
[/TR]
[TR]
[TD]range
[/TD]
[TD].5
[/TD]
[TD]15.5
[/TD]
[/TR]
[TR]
[TD]range
[/TD]
[TD].5
[/TD]
[TD]16
[/TD]
[/TR]
[TR]
[TD]range
[/TD]
[TD].5
[/TD]
[TD]16.5
[/TD]
[/TR]
[TR]
[TD]Blank area
[/TD]
[TD]5
[/TD]
[TD]17
[/TD]
[/TR]
[TR]
[TD]Total Blank area
[/TD]
[TD]10
[/TD]
[TD](Blank area + range)[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]Pointer Value
[/TD]
[TD]14
[/TD]
[/TR]
[TR]
[TD]
[TABLE="width: 228"]
<tbody>[TR]
[TD]Pointer width
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD].1
[/TD]
[/TR]
[TR]
[TD]Blank Area
[/TD]
[TD]-4.6 ((blank area+range)- (Pointer value+Pointer Width))
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]Speedometer data
[/TD]
[TD][/TD]
[TD]Series level
[/TD]
[/TR]
[TR]
[TD]Starting point
[/TD]
[TD][/TD]
[TD]12
[/TD]
[/TR]
[TR]
[TD]range
[/TD]
[TD].5
[/TD]
[TD]12.5 (12+.5)
[/TD]
[/TR]
[TR]
[TD]range
[/TD]
[TD].5
[/TD]
[TD]13
[/TD]
[/TR]
[TR]
[TD]range
[/TD]
[TD].5
[/TD]
[TD]13.5
[/TD]
[/TR]
[TR]
[TD]range
[/TD]
[TD].5
[/TD]
[TD]14
[/TD]
[/TR]
[TR]
[TD]range
[/TD]
[TD].5
[/TD]
[TD]14.5
[/TD]
[/TR]
[TR]
[TD]range
[/TD]
[TD].5
[/TD]
[TD]15
[/TD]
[/TR]
[TR]
[TD]range
[/TD]
[TD].5
[/TD]
[TD]15.5
[/TD]
[/TR]
[TR]
[TD]range
[/TD]
[TD].5
[/TD]
[TD]16
[/TD]
[/TR]
[TR]
[TD]range
[/TD]
[TD].5
[/TD]
[TD]16.5
[/TD]
[/TR]
[TR]
[TD]Blank area
[/TD]
[TD]5
[/TD]
[TD]17
[/TD]
[/TR]
[TR]
[TD]Total Blank area
[/TD]
[TD]10
[/TD]
[TD](Blank area + range)[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]Pointer Value
[/TD]
[TD]14
[/TD]
[/TR]
[TR]
[TD]
[TABLE="width: 228"]
<tbody>[TR]
[TD]Pointer width
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD].1
[/TD]
[/TR]
[TR]
[TD]Blank Area
[/TD]
[TD]-4.6 ((blank area+range)- (Pointer value+Pointer Width))
[/TD]
[/TR]
</tbody>[/TABLE]
Last edited: