software

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

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
tushar-mehta.com.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______

quot;MH UKquot; gt; wrote in message
...
gt;I have a scatter graph but would like to be able to edit the screen tip -
gt; when I hover over a point the screen tip shows the x and y values. I have
gt; a
gt; look up to the x value - this is not ideal as the x value may not be
gt; unique
gt; and requires the user to input the x value to a cell for the look up to
gt; retrieve the required data.
gt;
gt; Is there any way that I can edit the data source that the screen-tip /
gt; hover
gt; displays (e.g. offsetting from the column the data value is retrieved
gt; from)
gt; or do I have to merge my x and y values to ensure that the look-up is
gt; searching a unique value.
gt;
gt; Thanks in anticipation
Thanks Jon.
I will try not to be put off by quot;It's a lot of workquot; and see what I can do.

quot;Jon Peltierquot; wrote:

gt; You can't edit the chart tip, but you can fake it with chart event macros
gt; and custom formatted textboxes. It's a lot of work, but you can download
gt; Tushar Mehta's free Chart Hover Label utility to handle it for you, from
gt; tushar-mehta.com.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt; quot;MH UKquot; gt; wrote in message
gt; ...
gt; gt;I have a scatter graph but would like to be able to edit the screen tip -
gt; gt; when I hover over a point the screen tip shows the x and y values. I have
gt; gt; a
gt; gt; look up to the x value - this is not ideal as the x value may not be
gt; gt; unique
gt; gt; and requires the user to input the x value to a cell for the look up to
gt; gt; retrieve the required data.
gt; gt;
gt; gt; Is there any way that I can edit the data source that the screen-tip /
gt; gt; hover
gt; gt; displays (e.g. offsetting from the column the data value is retrieved
gt; gt; from)
gt; gt; or do I have to merge my x and y values to ensure that the look-up is
gt; gt; searching a unique value.
gt; gt;
gt; gt; Thanks in anticipation
gt;
gt;
gt;