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.
Tell me more
×
Super User is a question and answer site for
computer enthusiasts and power users. It's 100% free, no registration required.
|
|
|
You could use this addon http://www.appspro.com/Utilities/ChartLabeler.htm |
|||||
|
|
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 |
|||
|
|
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. |
|||
|
