Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Chart title: Text and Formula together? VBA
I'm trying to use Excel VBA to autocreate a chart title based on a cell value. This is what I've got so far:
Code:
.ChartTitle.Text = "Progress (as of " & "='OtherSheet'!R6C7" & ")" The "August 28, 2012" is written in a cell in another sheet. I've tried double quotes, I've tried putting the = before the text and in the formula. The above code results everything written out as text, including the formula. It is just listing the formula as text, and it's not actually getting the value of that cell. Does anyone know the correct syntax to get this to work? |
#2
|
|||
|
|||
Quote:
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart title: Text and Formula together? VBA
On Tuesday, August 28, 2012 11:10:03 AM UTC-5, KeriM wrote:
I'm trying to use Excel VBA to autocreate a chart title based on a cell value. This is what I've got so far: Code: -------------------- .ChartTitle.Text = "Progress (as of " & "='OtherSheet'!R6C7" & ")" -------------------- It's supposed to say (as an example): Progress (as of August 28,2012) The "August 28, 2012" is written in a cell in another sheet. I've tried double quotes, I've tried putting the = before the text and in the formula. The above code results everything written out as text, including the formula. It is just listing the formula as text, and it's not actually getting the value of that cell. Does anyone know the correct syntax to get this to work? -- KeriM Try this Sub charttitlesas() With ActiveSheet.ChartObjects("Chart 2").Chart ..HasTitle = True ..charttitle.Characters.Text = "My Date is " & _ sheets("sheet10").Range("e1") End With End Sub |
#4
|
|||
|
|||
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Chart title and text formula? | Charts and Charting in Excel | |||
Chart Title = Cell Text? | Excel Discussion (Misc queries) | |||
Replacing Chart title with Text box | Charts and Charting in Excel | |||
Chart title text linked from a cell? Possible? | Excel Discussion (Misc queries) | |||
dynamic chart title text | Excel Discussion (Misc queries) |