Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA to change size of data labels? | Charts and Charting in Excel | |||
Getting data labels right.... | Charts and Charting in Excel | |||
Excel should let me align data labels in different series (Excel . | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Help with pivot charts and data labels | Charts and Charting in Excel |