Skip to main content
Super User

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

3
  • 2
    Based on the information you provided, I would try to plot the data as an XY scatter. You can plot the actual positions and the estimations as two separate series on the same chart. Once both series are plotted, you can edit the properties of each one individually to change the point style to a circle, change the point color/size, etc. I would start by plotting just the actual position data, then once you've got it looking the way you want it, right click the chart and add a new series to plot the second one.
    – user2800
    Commented Mar 26, 2019 at 12:26
  • Note, if you plot the coordinates of your shape in the X-Y scatter plot, you will not be able to fill the closed shape with a flood fill type function. You can approximated it though with a series of closely spaced lines going from one side to the other. Also you wont be able to plot true circle easily (if at all) You can approximated it with multiple points on the circle. The more points you use the smoother it will look. Alternatively you can also try using polynomial lines to generate curves, but it may take some work to get them looking right.
    – Forward Ed
    Commented Mar 26, 2019 at 13:43
  • I suspect you need the approach in my tutorial Multiple Series in One Excel Chart.
    – Jon Peltier
    Commented Apr 2, 2019 at 3:30