Mark Tips for data not part of the series
Posted: Tue May 01, 2007 7:22 am
Hi,
I would like to have the mark tips showing data that is not part of the series. For example, I've a dataset:
date, sales, demand, description
'1-Jan-2007',400,300,'Apple'
'2-Jan-2007',300,300,'Orange'
I've 2 series on the chart, sales & demand plotted against date, which uses data from the above dataset. If I were to use the XY function for Mark Tips, I would get the date and either sales or demand data depending on which series the mouseover is.
However, if I also want to show the description (and XY data) for the sales series only but having the demand series to just have XY data, how could I achieve this?
I've read on other threads that Get Text function can plot other data apart from XY data, but I'm not sure if it can be used for this case.
Please advise. Thank you.
I would like to have the mark tips showing data that is not part of the series. For example, I've a dataset:
date, sales, demand, description
'1-Jan-2007',400,300,'Apple'
'2-Jan-2007',300,300,'Orange'
I've 2 series on the chart, sales & demand plotted against date, which uses data from the above dataset. If I were to use the XY function for Mark Tips, I would get the date and either sales or demand data depending on which series the mouseover is.
However, if I also want to show the description (and XY data) for the sales series only but having the demand series to just have XY data, how could I achieve this?
I've read on other threads that Get Text function can plot other data apart from XY data, but I'm not sure if it can be used for this case.
Please advise. Thank you.