Timeline for Scatter chart with corresponding XY pairs
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 2, 2019 at 3:30 | comment | added | Jon Peltier | I suspect you need the approach in my tutorial Multiple Series in One Excel Chart. | |
| Mar 26, 2019 at 13:43 | comment | added | Forward Ed | 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. | |
| Mar 26, 2019 at 12:26 | comment | added | user2800 | 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. | |
| Mar 26, 2019 at 12:05 | review | First posts | |||
| Mar 26, 2019 at 18:12 | |||||
| Mar 26, 2019 at 12:03 | history | asked | uqjwhidq | CC BY-SA 4.0 |