If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel should let me align data labels in different series (Excel . | dlearndeltondo | Charts and Charting | 0 | February 10th, 2005 08:45 PM |
VBA Code problem error 9 | Speedy | General Discussion | 19 | October 15th, 2004 09:05 PM |
Disappearing Data Labels | Erin | General Discussion | 2 | August 25th, 2004 05:08 PM |
How to create graphs in a monthly report where the base data can change | John Clarke | Charts and Charting | 3 | June 25th, 2004 02:22 AM |
Data labels in scatter charts | Joshua | Charts and Charting | 1 | April 17th, 2004 06:55 PM |