Hello guys,
I have searched the forum but i cannot find something similar to my actual problem.
I tried to make a classic speedometer with doughnut and pie chart and it does not work properly (ex. my value is 80 and the needle is somewhere else totally)
I use excel 2013.
The speedometer should only be between those values
I will list my values below as well my thresholds for the chart.
[TABLE="class: grid, width: 100, align: left"]
<tbody>[TR]
[TD]C/R[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Values[/TD]
[TD]Red[/TD]
[TD]Light red[/TD]
[TD]Yellow[/TD]
[TD]Light Yellow[/TD]
[TD]Green[/TD]
[TD]Light Green[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR="class: grid"]
[TD="width: 86, align: right"]53%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]30%[/TD]
[TD]40%[/TD]
[TD]50%[/TD]
[TD]60%[/TD]
[TD]70%[/TD]
[TD]80%[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR="class: grid"]
[TD="width: 86, align: right"]87%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]76%
[/TD]
[TD]80%
[/TD]
[TD]84%
[/TD]
[TD]88%
[/TD]
[TD]92%
[/TD]
[TD]96%
[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR="class: grid"]
[TD="width: 86, align: right"]36%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]50%
[/TD]
[TD]40%
[/TD]
[TD]30%
[/TD]
[TD]20%
[/TD]
[TD]15%
[/TD]
[TD]10%
[/TD]
[/TR]
</tbody>[/TABLE]
Can you guys please help me out? I am stressed out for the last 3 weeks. Tried everything and i cannot figure it out.
Thank you very much,
Razvan
I have searched the forum but i cannot find something similar to my actual problem.
I tried to make a classic speedometer with doughnut and pie chart and it does not work properly (ex. my value is 80 and the needle is somewhere else totally)
I use excel 2013.
The speedometer should only be between those values
I will list my values below as well my thresholds for the chart.
[TABLE="class: grid, width: 100, align: left"]
<tbody>[TR]
[TD]C/R[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Values[/TD]
[TD]Red[/TD]
[TD]Light red[/TD]
[TD]Yellow[/TD]
[TD]Light Yellow[/TD]
[TD]Green[/TD]
[TD]Light Green[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR="class: grid"]
[TD="width: 86, align: right"]53%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]30%[/TD]
[TD]40%[/TD]
[TD]50%[/TD]
[TD]60%[/TD]
[TD]70%[/TD]
[TD]80%[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR="class: grid"]
[TD="width: 86, align: right"]87%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]76%
[/TD]
[TD]80%
[/TD]
[TD]84%
[/TD]
[TD]88%
[/TD]
[TD]92%
[/TD]
[TD]96%
[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR="class: grid"]
[TD="width: 86, align: right"]36%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]50%
[/TD]
[TD]40%
[/TD]
[TD]30%
[/TD]
[TD]20%
[/TD]
[TD]15%
[/TD]
[TD]10%
[/TD]
[/TR]
</tbody>[/TABLE]
Can you guys please help me out? I am stressed out for the last 3 weeks. Tried everything and i cannot figure it out.
Thank you very much,
Razvan