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.
No. The order of size is: Jupiter (largest) Saturn Uranus Neptune Earth Venus Mars Mercury (smallest). So Neptune is the fourth largest planet, not the third.Pluto is now no longer classed as a major planet but is one of the minor planets beyond Neptune. if it had been included in the above list it would have been the smallest, even smaller than Mercury.hen looking for the3rd largest â¦ planet in the solar system: by mass the third largest planet is Neptune (after Jupiter and Saturn).by radius it is Uranus (likewise, after Jupiter and Saturn). 1 person found this useful. JD Heyl.