Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using DataLabels to Annotate a Chart Series

Status
Not open for further replies.

SkipVought

Programmer
Dec 4, 2001
47,492
US


It seems that the DataLabel object has a TOP & LEFT property, but not a HEIGHT & WIDTH property.

I am using a range to enter annotations to a series and linking that range to the DataLabel.

I am using the TOP property to move the DataLabel up and I am ADDING an ARROW shape, pointing down to the series.

I'd would have liked to vary the TOP property of the ARROW using the TOP and HEIGHT properties of the DataLabel, but, alas, there is no HEIGHT property.

Does anyone have a solution short of using textboxes in lieu of the DataLabel?

Skip,

[glasses] [red]Be Advised![/red] The only distinction between a bird with one wing and a bird with two, is merely...
a difference of A Pinion! [tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top