Pie Chart Needle Pointing to Correct Degree

[DashboardNovice]

In the attached file, column D has only one value which is in cell D51 which has a value of 7.5 which corresponds to the 45th degree in a circle.

I used Insert > Shapes to show what I am trying to do. See the yellow circle which has a radius pointing at the 45 degrees and it displays 7.5 as a data label.

The green circle graph is my attempt at getting what I want.

1. I guess the value of 7.5 corresponds to the green area, but why is there a white line? What does that represent?
2. Below the green circle, instead of 360 categories, there are 316. This is because I am starting at 0 degrees and ending on 360 degrees. Would it be better to start with 0 and end on 359 or start with 1 and end on 360?

The challenge I'm facing is how to get a radius line to point to the 45 degree angle in this case.

After searching I just can't find anything on how to do this.

 

[vletm]

DashboardNovice​

1) It's a border, which You've left there.
2) I would do something like this way ... check this sample
The challenge) Try to do it other ways.

 

[DashboardNovice]

DashboardNovice​

1) It's a border, which You've left there.
2) I would do something like this way ... check this sample
The challenge) Try to do it other ways.

Nice. I'll have to study it. Thank you. This is awesome.

 

[DashboardNovice]

DashboardNovice​

1) It's a border, which You've left there.
2) I would do something like this way ... check this sample
The challenge) Try to do it other ways.

Now I understand how you did this. I expanded on that and created another one (the blue one) and overlayed that on top of the first circle, but the blue circle has a faint vertical line from the center. I selected each slice and did remove borders and that didn't make it go away.

This line is at one of the slices/data points. How do I get rid of it?

Also in cell C2, why did you divide C3/2? I can't figure out the reason for that.

 

[vletm]

You should continue study...
There are different kind of 'Chart Designs.
You left there (Your version) border lines.
Each part can have own colors and so.
Case C2 ...
If 'needle' have weight then it can find one side of it.
... try to figure ... try to change width of needle.
I did something which You ... maybe ... tried to do.