If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Setting hover data labels to cells other than source data
Hi and thanks in advance,
I need a macro or something that will show a data label for a data source point when clicked or moved over by a mouse. I also need this data label to reference a different source than the source data used in the plot. For example, I am graphing a yield curve in relation to duration, however, instead of showing the x (duration) and y (yield) with the data label, I would like it to show the name of the instrument. x = column a, y = column b, instrument name = column c, for example. I have already tried using the tashar mehta macro for hovering data labels but it seems to break down rather easily. Perhaps it is not compatible with my excel version. If you have advice on how to make a macro, or where to get one from that will perform this operation I would appreciate it. Thanks, Darren |
#2
|
|||
|
|||
Setting hover data labels to cells other than source data
Hi,
You could plot each point as a unique series. Then the name, x and y will be displayed in the built-in popup labels. This method does restrict you to 254 points though. Remember to keep the original data series in the chart to give you the curve. Cheers Andy Darren wrote: Hi and thanks in advance, I need a macro or something that will show a data label for a data source point when clicked or moved over by a mouse. I also need this data label to reference a different source than the source data used in the plot. For example, I am graphing a yield curve in relation to duration, however, instead of showing the x (duration) and y (yield) with the data label, I would like it to show the name of the instrument. x = column a, y = column b, instrument name = column c, for example. I have already tried using the tashar mehta macro for hovering data labels but it seems to break down rather easily. Perhaps it is not compatible with my excel version. If you have advice on how to make a macro, or where to get one from that will perform this operation I would appreciate it. Thanks, Darren -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Macro to Copy & Paste | [email protected] | Worksheet Functions | 0 | December 1st, 2005 01:56 PM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |
Data Source issues. ??data.access.pages | Phil | Database Design | 2 | October 11th, 2004 02:42 AM |
Data Source issues | Philippe | Database Design | 1 | October 10th, 2004 09:45 PM |