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
|
|||
|
|||
Editing the screen tip on a scatter graph
I have a scatter graph but would like to be able to edit the screen tip -
when I hover over a point the screen tip shows the x and y values. I have a look up to the x value - this is not ideal as the x value may not be unique and requires the user to input the x value to a cell for the look up to retrieve the required data. Is there any way that I can edit the data source that the screen-tip / hover displays (e.g. offsetting from the column the data value is retrieved from) or do I have to merge my x and y values to ensure that the look-up is searching a unique value. Thanks in anticipation |
#2
|
|||
|
|||
Editing the screen tip on a scatter graph
You can't edit the chart tip, but you can fake it with chart event macros
and custom formatted textboxes. It's a lot of work, but you can download Tushar Mehta's free Chart Hover Label utility to handle it for you, from http://tushar-mehta.com. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "MH UK" wrote in message ... I have a scatter graph but would like to be able to edit the screen tip - when I hover over a point the screen tip shows the x and y values. I have a look up to the x value - this is not ideal as the x value may not be unique and requires the user to input the x value to a cell for the look up to retrieve the required data. Is there any way that I can edit the data source that the screen-tip / hover displays (e.g. offsetting from the column the data value is retrieved from) or do I have to merge my x and y values to ensure that the look-up is searching a unique value. Thanks in anticipation |
#3
|
|||
|
|||
Editing the screen tip on a scatter graph
Thanks Jon.
I will try not to be put off by "It's a lot of work" and see what I can do. "Jon Peltier" wrote: You can't edit the chart tip, but you can fake it with chart event macros and custom formatted textboxes. It's a lot of work, but you can download Tushar Mehta's free Chart Hover Label utility to handle it for you, from http://tushar-mehta.com. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "MH UK" wrote in message ... I have a scatter graph but would like to be able to edit the screen tip - when I hover over a point the screen tip shows the x and y values. I have a look up to the x value - this is not ideal as the x value may not be unique and requires the user to input the x value to a cell for the look up to retrieve the required data. Is there any way that I can edit the data source that the screen-tip / hover displays (e.g. offsetting from the column the data value is retrieved from) or do I have to merge my x and y values to ensure that the look-up is searching a unique value. Thanks in anticipation |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Full screen Word window opens half way down the screen | toreddie | General Discussion | 0 | December 28th, 2005 06:57 PM |
questions regarding MS Graph | Zlatko Matić | General Discussion | 0 | December 16th, 2005 12:06 PM |
how can I automatically put labels in a scatter graph (.xls) ? | emilie | Charts and Charting | 1 | March 1st, 2005 08:49 AM |
xy scatter graph with a scrolling time element | Brad | Charts and Charting | 2 | January 7th, 2005 01:53 PM |
Jump from Blank screen to slide N during presentation | Yohs | Powerpoint | 3 | December 30th, 2004 07:23 PM |