Names as data labels or markers in Excel 2007?
November 28, 2007 9:03 AM Subscribe
Excel 2007 charting: Can you tell me how to use the name of a point as the data marker or the data label in an X-Y scatter plot?
posted by muhonnin to Computers & Internet (4 answers total)
I have about 75 - 80 points that I'd like to display in an X-Y scatterplot in Excel 2007. Each point has a name consisting of a letter and a number: point A1 is (3, 3), point A2 is (4,6), point B1 is (2,1), etc. My point names are in column A, my x values are in column B, and my y values are in column C. Ideally, instead of a lot of blue diamonds scattered across the chart, I'd like to be the markers to be the point names (A1, A2, etc.). If that's not possible, I'd settle for being able to use the point names as data labels next to the blue diamonds. The only options I seems to be able to access for the data label are the X value, the Y value, or the name of the whole series.
Apologies if I'm missing something obvious--an hour of exploring the help facility and Googling have not been very illuminating. I'd be happy to implement a simple VBA script or macro if that would help.