Hi... In setting up an XY scatter graph I have used a macro (taken from another post) to add the data labels however this macro actual plots the data labels on the chart. I just need to be able to have the labels show up when the particular plot is selected by pointing on the graph. I have tried to hide the data labels through the normal chart options toolbar without success. Can someone please assist.
Secondly, I need to add a 45 degree trendline through the chart.. Any suggestions to accomplish this
Thanks