I have 3 columns of data: name, magnitude and frequency. I wish to plot a scatter graph of magnitude vs frequency and have each data point relate to its name (ie when the mouse is held over the data point on the graph its name will be shown). Due to the quantity of data I don’t want to manually create an individual series for each data point. Can anyone help?
You could get close to this by building your own bespoke graphing functionality. Have a look at the download on my homepage for an example.
Martin
Eighty Twenty Spreadsheet Automation http://homepage.ntlworld.com/martin.rice1/ for all your Excel customisation and consulting needs.
If my solution has saved you time and/or money, please consider donating to Cancer Research UK.
You could also use this tool...
http://www.appspro.com/Utilities/ChartLabeler.htm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks