G
Guest
I know there are some great chart labelling tools out there, but I decided to
go it alone.... I can label a chart using a routine which reads a stats
report, and labels a,b or c or any combination of, depending on which groups
are different from control. Works great. But, I'm using xlLabelPositionAbove,
which sometimes plonks the labels on the error bars. I could use the
datalabel.top, but this is a bit rigid. How can I make the label position a
bit more dynamic so that it relates to the position of the point, and
possibly the size of the error bar. How do I ask excel where a point is on
the graph? thanks muchly
go it alone.... I can label a chart using a routine which reads a stats
report, and labels a,b or c or any combination of, depending on which groups
are different from control. Works great. But, I'm using xlLabelPositionAbove,
which sometimes plonks the labels on the error bars. I could use the
datalabel.top, but this is a bit rigid. How can I make the label position a
bit more dynamic so that it relates to the position of the point, and
possibly the size of the error bar. How do I ask excel where a point is on
the graph? thanks muchly