Polar Scatter graph/Bulls Eye in Excel

[daxeman]

Hi,

I am trying to create a scatter graph that shows hole deviation between several drill hole collar locations.

I have the x and y axes values of the design holes as well as the actual drilled holes and I want to compare the deviation between the design drill holes position and the actual drill hole positions.

Appreciate any suggestions or help with my query.

 

[vletm]

daxeman
Here are three charts.
If any of those didn't match Your needs then try to explain other way.

 

[daxeman]

daxeman
Here are three charts.
If any of those didn't match Your needs then try to explain other way.

Hi vletm,

Thank you, I am trying to create a polar scatter plot that shows deviation as a dot on the polar scatter plot.



Shown below is an example of a polar scatter plot that I am trying to replicate.



Thank you for your help.

Regards,
Doug

 

[daxeman]

Hi vletm,

Thank you, I am trying to create a polar scatter plot that shows deviation as a dot on the polar scatter plot.

View attachment 79372

Shown below is an example of a polar scatter plot that I am trying to replicate.

View attachment 79371

Thank you for your help.

Regards,
Doug

 

[vletm]

daxeman
It needs two values to get a polar scatter plot - You named ... one.
with Difference- sample ... it looks something same - that I am trying to replicate.
... could You give that plot's data?
with Deviation- sample ... it shows Your original files deviation

 

[p45cal]

In your first attached file, if you were to plot column L (x) and column O (y) you'd have your 'polar' plot.
Your deviation column M I can understand; it's the distance from the target (pythagoras) and contains no angular information. It could help you in colouring the points on the chart, or putting labels on the points indicating their distances from the target.
You have another deviation column with column P although I think you might have that formula wrong (I'm no mechanical engineer) because you root only the first part of the formula, not the whole.
Your formula is:
=SQRT((G3-B3)^2)+((H3-C3)^2)
where the red highighted part is a sqrt directly after squaring, which only serves to return the absolute value of G3-B3, so your formula there can be re-written:
=ABS(G3-B3)+(H3-C3)^2
and I'm not clear on what that value gives you.
For each point I think you only have one deviation (the distance between target hole centre and actual hole centre), so I don't think you need two columns for this.

 

[KenU]

Please see the attached.

Hope that helps!

Regards,
Ken

 

[KenU]

Here is a picture of the chart from my previous post.

 

[daxeman]

Here is a picture of the chart from my previous post.

View attachment 79420

This is exactly what I am after! Thank you so much @KenU!!