Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Labels and chart sheets
Hello
Is it possible to put a label (from the developer tools) on a chart sheet and edit the caption VBA? I'd like to be able to display information on those labels when I click on a data point on a chart. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Labels and chart sheets
Here's how to add a label with VBA:
Sub AddLabel() ' remove old label with same name On Error Resume Next ActiveChart.Shapes("MyLabel").Delete On Error GoTo 0 ActiveChart.Shapes.AddShape(msoShapeRectangle, 75, 50, 125, 25).Name = "MyLabel" End Sub And here's how to change what appears in the label: Sub JustPopulateLabel() With ActiveChart.Shapes("MyLabel").TextFrame .Characters.Text = "Here's what I want to say." End With End Sub - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Revolveri" wrote in message ... Hello Is it possible to put a label (from the developer tools) on a chart sheet and edit the caption VBA? I'd like to be able to display information on those labels when I click on a data point on a chart. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XY Chart Labels | Charts and Charting in Excel | |||
Chart labels disappear - How do I refresh the chart? | Charts and Charting in Excel | |||
XY chart with labels | Charts and Charting in Excel | |||
chart labels? | Charts and Charting in Excel | |||
Chart sheets cause data sheets to be blank | Charts and Charting in Excel |