![]() For 50 rows it would quickly be brutal, so it is best to look at a macro-oriented approach. ![]() This can be done manually, but it is tedious at best. Martin wonders if there is a way he can easily use Column A to label the plotted data points. When he tries to label the data points the only available options are to label each point with its X value, Y value, or Series Name. However, Martin can't seem to label the data points with their individual names (from column A). When he creates an X-Y scatter chart (column B against column C) the result, as desired, is a graph showing an array of points showing the location of the objects. Column A contains the name of the object, column B contains its X coordinate, and column C contains its Y coordinate. ![]() Martin has a worksheet containing 50 rows of data, each row describing a single object. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
May 2023
Categories |