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.
Venusâ mass is only approximately 81% of Earthâs mass, so it is not surprising that Venus is also less dense than our own planet. Venus has a density of 5.204 grams per cubic centimeter. Earth is the densest planet in our Solar System.ust like the size of the planets, the density of the planets varies widely. All of the 4 inner planets â the planets closest to the Sun â are much denser than the four outer planets. That is because the inner planets, which are also called terrestrial planets, are made up of heavy metals and rocks.