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.
According to NASA, about 1000 Earths can fit inside Jupiter. The massive fifth planet is large enough to hold all the planets in the solar system... According to NASA, about 1000 Earths can fit inside Jupiter. The massive fifth planet is large enough to hold all the planets in the solar system easily. Jupiter is home to the Great Red Spot, which itself is about three times larger than Earth. Mostly made of helium and hydrogen, Jupiter is considered to be a gas giant, and it is five times further from the sun than Earth. Due to Jupiter's speedy rotation, a typical day on the planet only lasts about 10 hours, and it takes 12 years for this planet to make a complete orbit around the sun. Learn more about Planets