Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Apologies For No Subject. Chart Title via a Macro
Sorry for the double post
"Alan" wrote in message news:... Hi, ActiveChart.SetSourceData Source:=Sheet5.Range([R35]) I have a macro which will give graphic display of data from several sources via the contents of Sheet5.Range([R35]) in the above snippet of code. The contents of this cell are changed by a VLOOKUP table with the lookup value coming from a combo box . My question is, can I do a similar thing with the TITLE of the chart. That is to say, change the title to reflect the values shown from the same data source by putting the title in a cell, say Sheet5.Range("A1") then using Sheet5.Range([A1]) in the macro. I have tried all (the little) I know and searched Google to no avail. Any advice will be gratefully received. Reading this, I'm not sure if I've made clear what I'm trying to do, I hope I have TIA Alan. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for chart title | Charts and Charting in Excel | |||
Using macro to set chart title with a variable month | Excel Discussion (Misc queries) | |||
Can I use file information (title, subject,) as fields in Excel? | Excel Discussion (Misc queries) | |||
Excel 2007 Macro/Link Issue (apologies for cross-posting) | Links and Linking in Excel | |||
Pasting Objects into Chart title and Axis title | Charts and Charting in Excel |