Excel scatter plot how to#
How to Modify the Plot to Achieve the Result You Need Let’s have a closer look now at several possibilities how we can modify the plot to achieve the result we need. The scatter plot is great for a visual representation of a relationship between any sets of data. For example, this point here shows the Cost-Profit relationship for the product A, where the Cost value is 400 and the Profit value 100. The dots we see in the plot are the points where the values for Cost and Profit intersect on the x- and y-axes. Just as we mentioned a while ago, the values from the column on the left – Cost – are on the x-axis and the data from column on the right – Profit – show on the y-axis. Excel will create the scatter plot and insert it within the area of the sheet. We’ll use this simple scatter plot – the first one at hand. There are numerous possibilities to choose from. Go to the Insert tab, find Charts and the option Scatter.Ĭlick on it. Once a clear data table has been prepared and we’ve selected the values to be used in the chart, we can insert the scatter plot in several easy clicks. Therefore, take your time and make sure to organise the collected data within a table with great care.
Then it’s good to know that well prepared data within a clear table can be of great help, because when you simply select two columns with values to be used in the plot, the column on the left will appear on the horizontal x-axis and the column on the right will be displayed on the vertical y-axis.
How to Prepare Clear Data Table in Excel Chart The x- as well as y-axis will consist of numerical data only. Here we’ll focus on the scatter plot, which we’ll use to show the relationship between Cost and Profit.īefore we get started though, it’s essential to point out a couple of important details.įirst, it’s crucial to realise that unlike other chart types, the scatter plot standardly works with numbers. In previous tutorials, we had a look at how to create a line graph or a bar chart. In Excel, there are various types of charts available to visually display collected data.
0 kommentar(er)
