![]() ![]() ![]() So, we need to figure out a way to find, highlight and, optionally, label only a specific data point. But our scatter graph has quite a lot of points and the labels would only clutter it. If we had fewer points, we could simply label each point by name. Now, you want to be able to quickly find the data point for a particular month. Supposing, you have two columns of related numeric data, say monthly advertising costs and sales, and you have already created a scatter plot that shows the correlation between these data: Show a position of average or benchmark point.Show the position of the data point on x and y axes.Change the appearance (color, fill, border, etc.).Add a new data series for the data point.Extract x and y values for the data point.Professional data analysts often use third-party add-ins for this, but there is a quick and easy technique to identify the position of any data point by means of Excel. ![]() In situations when there are many points in a scatter graph, it could be a real challenge to spot a particular one. Today, we will be working with individual data points. Last week we looked at how to make a scatter plot in Excel. The tutorial shows how to identify, highlight and label a specific data point in a scatter chart as well as how to define its position on the x and y axes. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |