Each of these new column pairs will be used to plot a series of smaller concentric bull’s-eye circles. When plotted on an Excel Scatter Chart, these data points will form a total of four circles, ...

If you need to create a Line Chart and Scatter Plot in Excel, read through this article. We have also explained which one is right for you.

How to Plot Two Things on the Same Y Axis in Excel. Properly formatted charts and graphs can help you grasp the patterns and trends hidden within the raw data of an Excel spreadsheet.