Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign Chart Title w/ VBA
Last month, Jon Peltier was kind enough to give me the below code to set a Chart's Title
With ActiveWorkbook.Worksheets("OneMonth").ChartObjects (2).Char .HasTitle = Tru .ChartTitle.Text = "Monthly Scrap Dollars End Wit My question, I am not able to concatenate a named Range like.. .ChartTitle.Text = "Monthly Scrap Dollars " & ATitle --- where ATitle is a named range filled i thru automation within Access (yes it works from Access)...IE "From 1/1/04 To 1/19/04 I am trying similar code, but it won't work...only a string w/o concatenation is working Can it be done TIA - Bo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign Chart Title w/ VBA
Answered in the charting group.
- Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ Bob Barnes wrote: Last month, Jon Peltier was kind enough to give me the below code to set a Chart's Title. With ActiveWorkbook.Worksheets("OneMonth").ChartObjects (2).Chart .HasTitle = True .ChartTitle.Text = "Monthly Scrap Dollars" End With My question, I am not able to concatenate a named Range like... .ChartTitle.Text = "Monthly Scrap Dollars " & ATitle --- where ATitle is a named range filled in thru automation within Access (yes it works from Access)...IE "From 1/1/04 To 1/19/04" I am trying similar code, but it won't work...only a string w/o concatenation is working. Can it be done? TIA - Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to display the Chart Name as a Chart Title? | Charts and Charting in Excel | |||
How to hide a chart title, but keep the title in the chart | Charts and Charting in Excel | |||
Dynamic Chart Title With 3D Stacked Column Chart | Charts and Charting in Excel | |||
Excel chart - how to assign the file name in the chart title? | Charts and Charting in Excel | |||
Pasting Objects into Chart title and Axis title | Charts and Charting in Excel |