M
MH UK
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
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