Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have three columns of data. Column 1 has a short description, column 2 has a benefit number and column 3 has a cost. I can create a cost/benefit scatter chart, but what I want is to be able to have each point in the scatter chart be labeled with the description. I don't care if you can see it on the chart or you have to roll over the point to see the description.

share|improve this question
add comment

3 Answers

up vote 3 down vote accepted

You could use this addon http://www.appspro.com/Utilities/ChartLabeler.htm

share|improve this answer
    
+1 Looks good. I already did it the manual way, but this add-on looks useful for when I need to do this again. –  Leigh Riffel Oct 1 '10 at 12:59
    
+1 Excellent link! Wish I could up vote it more than once. BTW, works for all chart types with labels, not just XY. –  DaveParillo Oct 6 '10 at 3:11
add comment

There's another free utility (and tutorial on how to create it) available for download here: http://www.wiseowl.co.uk/blog/s130/excel-charts-data-labels-problem.htm

share|improve this answer
    
Could you perhaps describe this utility? Maybe include a tutorial? Generally we prefer answers involve more detail as opposed to just linking –  Simon Sheehan Nov 11 '11 at 21:46
add comment

At first, I thought you could accomplish this with a 'bait and switch' - make a plot of the data first, then edit the series. Doesn't work though. This works if and only if the numbers in column 'B' are whole numbers. The excel chart isn't really using any of the data in column B anymore.

The only way I have been able to reliably do this in the past is to make every row of data it's own data series. Painful, but if you want to see it in action, I have an example excel file.

share|improve this answer
    
+1 Every row of data as it's own series does work, but you are right it is painful to build. –  Leigh Riffel Sep 29 '10 at 17:34
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.