| 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? |
| 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 | |||
Threaded Mode
