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. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |