Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Simple...Update Text Box in Chart
Hello,
I have a chart in an MS Excel worksheet and I would like to change the value/caption of a textbox( Text Box 20). I have only been able to change the title of the chart with the following: With MyChart.Workbooks(1).Worksheets("Chart").ChartObje cts(1).Chart .HasTitle = True .ChartTitle.Text = "Summary of Report" & date() 'Add Today's Date End With Do I have to reference the chart or do I have to reference the textbox itself? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Simple...Update Text Box in Chart
Hi,
If the shape is actual embedded in the chart object then something like, ActiveChart.Shapes("Text Box 20").TextFrame.Characters.Text = _ "Hello World" If the shape is just over the chart then replace ActiveChart with Activesheet Cheers Andy Intui_Sol wrote: Hello, I have a chart in an MS Excel worksheet and I would like to change the value/caption of a textbox( Text Box 20). I have only been able to change the title of the chart with the following: With MyChart.Workbooks(1).Worksheets("Chart").ChartObje cts(1).Chart .HasTitle = True .ChartTitle.Text = "Summary of Report" & date() 'Add Today's Date End With Do I have to reference the chart or do I have to reference the textbox itself? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Simple...Update Text Box in Chart
Thank you very much! I knew I should have mentioned something about
shapes! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text label in x-axis (scatter chart) | Charts and Charting in Excel | |||
Scatter chart with text labels as Y axis? | Charts and Charting in Excel | |||
Chart title text linked from a cell? Possible? | Excel Discussion (Misc queries) | |||
Prevent non-numerical data (e.g. text) from plotting on a chart | Charts and Charting in Excel | |||
Why do my text boxes disappear from my chart when I click out? | Charts and Charting in Excel |