Chart types

[esengul]

i can not make change my chart type in VBA code
could you tell me why?
here is my code
everything works but not my charttype
Set oChart = oexcel.Charts.Add()
oChart.chartType = xlXYScatter
With oChart
.HasTitle = True
.HasLegend = False

.ChartTitle.Characters.Text = "Mercury Deposition Network - Matrix Duplicate Relative Percent Difference"
.Axes(1).HasTitle = True
.Axes(1).AxisTitle.Characters.Text = "January ~ December"
.Axes(3).HasTitle = False
.Axes(2).HasTitle = True
.Axes(2).AxisTitle.Characters.Text = "Relative Percent Difference"
End With

 

[SkipVought]

Hi,

Have you set a reference to the Excel x.y Object Library?

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}

 

[esengul]

no i havent and also i dont know how to that
thanks

 

[SkipVought]

in the vb editor Tools/References -- Microsoft Excel x.y Object Library.

This will be where the xl constants are defined (xlXYScatter is a constant)

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}

 

[esengul]

i didnt have the "Microsoft Excel x.y Object Library" in the list, i checked the "Microsoft Excel 10.0 Object Library"
And it worked
thanks alot

 

[SkipVought]

x.y == 10.0 ;-)

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}

 

[esengul]

duhhhhhhhhh. i am so dumb.
thanks again

 

[giuseppekingita]

use:
[chartname].Object.Application.chart.charttype = charttype

bye,
giuseppe