View Single Post
  #1  
Old March 31st, 2005, 07:29 PM
Rob
external usenet poster
 
Posts: n/a
Default "Bring to Front" Data Labels?

I have a chart that has lots of data labels, so many that some of the labels
become partially obscured. I have a routine that runs whenever a label is
clicked upon, and one of the things I'd *Like* to do is to mimic a drawing
object "Bring to Front" function. Is this possible?

The way the chart is constructed might help (or hurt) my chances: I am
graphing a tree chart, instantiated as an xlXYScatterLines Chart, and each
"node" in the tree is represented by a series with two points (node and
parent node). Each series gets one datalabel (at the node, i.e. the first
point in the series gets a label, the second doesn't).

I guess it's possible that I could re-order the series collection when the
label is selected, so that the series selected is last (and thus, I presume,
the datalabel is drawn last). I don't know if this would work, but I'd
really like to avoid this since it takes a couple of seconds to redraw the
chart, and that could get annoying...

Thanks!
Rob