![scatter chart in excel scatter chart in excel](https://cdn.ablebits.com/_img-blog/scatter/make-scatter-plot-excel.png)
The blank cell is given a value of zero.Excel can manage missing data or bank cells when creating scatter or line charts in three different ways:
#Scatter chart in excel how to
Here we discuss how to create Scatter Plot Chart in Excel along with practical examples and a downloadable excel template.Microsoft excel does not automatically connect data points in scatter or line charts when there is missing data or empty cells (see excel example below). This has been a guide to Excel Scatter Plot Chart. Axis Titles is nothing but Horizontal Axis (X-Axis) and Vertical Axis (Y-Axis).Because as a viewer, it is very difficult to understand the chart without Axis Titles. Always mention the Axis Title to make the chart readable.First, find if there is any relationship between two variable data sets otherwise, there is no point in creating a scatter diagram.You need to arrange your data to apply to a scatter plot chart in Excel.Because in this range of rainfall, farmers are very much interested in buying crops and does not matter about the price level. If you are analyzing the rainfall carefully, you can increase the prices of the crops if the rainfall is ranging between 40 to 60 cm.Otherwise, you have to deal with the stock of crops for a long time. As a crop seller, it is very important to assess the rainfall percentage and invest accordingly.If the rainfall is out of that range, then the crop sale decreases considerably.Rainfall should be in between 40 to 60 cm to expect a good amount of crop sales.It is very clear that crop sales are completely dependent on rainfall.At the same time even if the rainfall is not that great crops sale is very less.
![scatter chart in excel scatter chart in excel](https://i.ytimg.com/vi/DHnOi1C2V2c/maxresdefault.jpg)
At 100 cm rainfall, the crops purchased is declined to 12 kilos.
![scatter chart in excel scatter chart in excel](https://i.ytimg.com/vi/9NUjHBNWe9M/maxresdefault.jpg)
Select Axis Titles and enter axis titles manually. Step 9: Once you click on that chart, it will show all the options. Step 8: Select Legend and press the delete option. Step 7: Now, each marker looks bigger and looks a different color. Step 6: Go to Marker Options > Select Built-in > Change Size = 25. It will add different colors to each marker. Step 5: Click on the Marker Fill option and select Vary Colours by Point. In Excel 2010 and earlier versions, a separate box will open. On the right-hand side, an option box will open in excel 2013 & 2016. It will show you the below options, and press Ctrl + 1 (this is the shortcut key to formatting).
![scatter chart in excel scatter chart in excel](https://i.stack.imgur.com/QBMYX.png)
Step 3: It will insert the chart for you.