Step 1. Launch Excel and open the spreadsheet with the data to transform into an X-Y scatter plot diagram. Step 2. Highlight the columns or rows with the data to include in the scatter plot.Related Reading: How to Plot Scattergrams on Excel. Step 3. Click the âInsertâ tab, and then choose the âScatterâ menu from the Charts section of the ribbon.Step 4. Select one of the scatter plot diagram options, such as âScatter with only Markers,â âScatter with Smooth Lines and Markersâ or âScatter with Straight Lines.â The scatter plot is inserted into the Excel spreadsheet.tep 1. Launch Excel and open the spreadsheet with the data to transform into an X-Y scatter plot diagram. Step 2. Highlight the columns or rows with the data to include in the scatter plot.
For instance, Earth is the third planet from the sun and the fifth largest in the solar system. Earth's diameter is just a few hundred kilometers larger than that of Venus.
The Blue-Green Planet . Neptune is the fourth largest planet in the Solar System today. However, Neptune is the eighth planet and this planet is going to be the further planet away from the Sun; but the planet is considered to be the third largest mass planet. Neptune is going to be the densest of all planets in the Solar System and is a gas giant planet. Neptune has almost 17 times more mass than that found on Earth and will be smaller than Uranus which is very close to it. Neptune is named after the Roman god and it was discovered many, many years ago.