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.
Jupiter is the fifth planet from the Sun and the largest planet in the Solar System. It is a giant planet with a mass one-thousandth that of the Sun, but is two and a half times that of all the other planets in the Solar System combined. Jupiter is a gas giant, along with Saturn (Uranus and Neptune are ice giants).Jupiter was known to astronomers of ancient times.upiter is much larger than Earth and considerably less dense: its volume is that of about 1,321 Earths, but it is only 318 times as massive. Jupiter's radius is about 1/10 the radius of the Sun, and its mass is 0.001 times the mass of the Sun, so the density of the two bodies is similar. A .