Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manipulating Charts with VBA
Hi All,
When I try to use the code below to change some chart properties I get various error like " "Object doesn't support this method or property" (for the Refresh method) or the one which I can't recall at this moment but basically says that the property can't be changed (regarding the ChartTitle.Text property) Sheet_6.ChartObjects(1).Visible = True Sheet_6.ChartObjects(1).Chart.ChartTitle.Text = "Total Costs during Five Years of Analysis" Sheet_6.ChartObjects(1).Refresh Are these valid statements? Rick |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manipulating Charts with VBA
"Rick" wrote in message news:zhkgc.160673$K91.413926@attbi_s02... Hi All, When I try to use the code below to change some chart properties I get various error like " "Object doesn't support this method or property" (for the Refresh method) or the one which I can't recall at this moment but basically says that the property can't be changed (regarding the ChartTitle.Text property) Sheet_6.ChartObjects(1).Visible = True Sheet_6.ChartObjects(1).Chart.ChartTitle.Text = "Total Costs during Five Years of Analysis" Sheet_6.ChartObjects(1).Refresh I am no expert, but from the Object Browser it appears that you are using the wrong class for Chart.ChartTitle.Text There are two classes listed, one singular and the other plural: ChartObject ChartObjects The ChartTitle is a member of ChartObject, not ChartObjects |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manipulating Charts with VBA
try DrawingObjects instead of ChartObjects, and see if that works.
Brian Murphy "Colleyville Alan" wrote in message news:Z5lgc.16295$ru4.17030@attbi_s52... "Rick" wrote in message news:zhkgc.160673$K91.413926@attbi_s02... Hi All, When I try to use the code below to change some chart properties I get various error like " "Object doesn't support this method or property" (for the Refresh method) or the one which I can't recall at this moment but basically says that the property can't be changed (regarding the ChartTitle.Text property) Sheet_6.ChartObjects(1).Visible = True Sheet_6.ChartObjects(1).Chart.ChartTitle.Text = "Total Costs during Five Years of Analysis" Sheet_6.ChartObjects(1).Refresh I am no expert, but from the Object Browser it appears that you are using the wrong class for Chart.ChartTitle.Text There are two classes listed, one singular and the other plural: ChartObject ChartObjects The ChartTitle is a member of ChartObject, not ChartObjects |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manipulating Charts with VBA
Sheet_6.ChartObjects(1).Chart.ChartTitle.Text = "Total Costs during Five
Years of Analysis" give an error unless you make hascharttitle = true With Sheet_6.ChartObjects(1).Chart .HasTitle = True .ChartTitle.Text = "Total Costs during Five Years of Analysis" End With there is no refresh method for a chartobject. The chart is refreshed when a calculate is performed. -- Regards, Tom Ogilvy "Rick" wrote in message news:zhkgc.160673$K91.413926@attbi_s02... Hi All, When I try to use the code below to change some chart properties I get various error like " "Object doesn't support this method or property" (for the Refresh method) or the one which I can't recall at this moment but basically says that the property can't be changed (regarding the ChartTitle.Text property) Sheet_6.ChartObjects(1).Visible = True Sheet_6.ChartObjects(1).Chart.ChartTitle.Text = "Total Costs during Five Years of Analysis" Sheet_6.ChartObjects(1).Refresh Are these valid statements? Rick |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manipulating Charts with VBA
Alan -
ChartObjects(1) refers to the first ChartObject in the collection. Rick - If the chart has no title, you will be unable to change its text. Use this combination to add the title first: With Sheet_6.ChartObjects(1).Chart .HasChartTitle = True .ChartTitle.Text = "Total Costs during Five Years of Analysis" End With You can't refresh a chartobject, just a chart: Sheet_6.ChartObjects(1).Chart.Refresh - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Colleyville Alan wrote: "Rick" wrote in message news:zhkgc.160673$K91.413926@attbi_s02... Hi All, When I try to use the code below to change some chart properties I get various error like " "Object doesn't support this method or property" (for the Refresh method) or the one which I can't recall at this moment but basically says that the property can't be changed (regarding the ChartTitle.Text property) Sheet_6.ChartObjects(1).Visible = True Sheet_6.ChartObjects(1).Chart.ChartTitle.Text = "Total Costs during Five Years of Analysis" Sheet_6.ChartObjects(1).Refresh I am no expert, but from the Object Browser it appears that you are using the wrong class for Chart.ChartTitle.Text There are two classes listed, one singular and the other plural: ChartObject ChartObjects The ChartTitle is a member of ChartObject, not ChartObjects |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manipulating Charts with VBA
"Jon Peltier" wrote in message
... Alan - ChartObjects(1) refers to the first ChartObject in the collection. Thanks |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manipulating Charts with VBA
Jon Peltier wrote:
Alan - ChartObjects(1) refers to the first ChartObject in the collection. Rick - If the chart has no title, you will be unable to change its text. Use this combination to add the title first: With Sheet_6.ChartObjects(1).Chart .HasChartTitle = True .ChartTitle.Text = "Total Costs during Five Years of Analysis" End With You can't refresh a chartobject, just a chart: Sheet_6.ChartObjects(1).Chart.Refresh - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Colleyville Alan wrote: "Rick" wrote in message news:zhkgc.160673$K91.413926@attbi_s02... Hi All, When I try to use the code below to change some chart properties I get various error like " "Object doesn't support this method or property" (for the Refresh method) or the one which I can't recall at this moment but basically says that the property can't be changed (regarding the ChartTitle.Text property) Sheet_6.ChartObjects(1).Visible = True Sheet_6.ChartObjects(1).Chart.ChartTitle.Text = "Total Costs during Five Years of Analysis" Sheet_6.ChartObjects(1).Refresh I am no expert, but from the Object Browser it appears that you are using the wrong class for Chart.ChartTitle.Text There are two classes listed, one singular and the other plural: ChartObject ChartObjects The ChartTitle is a member of ChartObject, not ChartObjects Thanks everyone...and Jon you code works fine...thank you... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manipulating DOS from VBA | Excel Programming | |||
manipulating pictures with VBA | Excel Programming | |||
Manipulating Excel pie charts with VB | Excel Programming | |||
Manipulating Excel pie charts with VB | Excel Programming | |||
Manipulating Excel pie charts with VB | Excel Programming |