When plotted on an Excel Scatter Chart, these data points will form a total of four circles, effectively converting a scatter chart into a bull’s-eye chart. Your updated table containing the ...

How to overlap two series in Excel Overlapping the two series is one way to clear things up a bit. In other words, let’s move the target series so that it’s on top of the actual value series.