467,874 Members | 1,761 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,874 developers. It's quick & easy.

Creating Multiple charts in Excel

Hi all,

i am trying to automate multiple charts by manipulating macros.

i have data on 17 different sheets and wish to create a chart for the same data range in each sheet.

Problem is i keep getting run time error - 438, 'object dosen't support this property or method'

Any ideas?

Thanks..

P.S.

here is my code

Sub Macro1()
'
' Macro1 Macro
'

'
Dim i As Integer
For i = 1 To 17

Columns("B:G").Select
Charts.Add
ActiveChart.ChartType = xlXYScatterSmoothNoMarkers
ActiveChart.SetSourceData Source:=Sheets(i).Range("B1:G673"), PlotBy:= _
xlColumns
ActiveChart.Location Where:=xlLocationAsNewSheet
With ActiveChart
.HasTitle = False
.Axes(xlCategory, xlPrimary).HasTitle = False
.Axes(xlValue, xlPrimary).HasTitle = False
End With
Next i

End Sub
Nov 1 '06 #1
  • viewed: 2979
Share:

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Gargamil | last post: by
3 posts views Thread by implicate_order | last post: by
3 posts views Thread by saragoesnuts | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.