| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
as that was so easy...
As you nailed that one so easy...
The macro draws a chart from data on worksheet 1 then stores the chart as a new sheet. How do you... Title the chart with a word that is found in cell A9 of worksheet 1? Name the sheet that the chart is on with the same word? I owe you guys big time for this! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
as that was so easy...
Sub AAA()
ActiveChart.ChartTitle.Text = "=Sheet1!R9C1" ActiveChart.Name = Worksheets("Sheet1").Range("A9").Value End Sub -- Regards, Tom Ogilvy "Josie" wrote in message ... As you nailed that one so easy... The macro draws a chart from data on worksheet 1 then stores the chart as a new sheet. How do you... Title the chart with a word that is found in cell A9 of worksheet 1? Name the sheet that the chart is on with the same word? I owe you guys big time for this! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
as that was so easy...
Lawks...
-----Original Message----- Sub AAA() ActiveChart.ChartTitle.Text = "=Sheet1!R9C1" ActiveChart.Name = Worksheets("Sheet1").Range("A9").Value End Sub -- Regards, Tom Ogilvy "Josie" wrote in message ... As you nailed that one so easy... The macro draws a chart from data on worksheet 1 then stores the chart as a new sheet. How do you... Title the chart with a word that is found in cell A9 of worksheet 1? Name the sheet that the chart is on with the same word? I owe you guys big time for this! . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Easy One! | Excel Discussion (Misc queries) | |||
| Easy one for you all... | Excel Worksheet Functions | |||
| Is there an easy way to... | Excel Discussion (Misc queries) | |||
| Very easy I'm sure | Excel Discussion (Misc queries) | |||
| new user with easy question? not easy for me | New Users to Excel | |||
Hybrid Mode
