what the problem?

  • Thread starter Christoph Strobelt [Bt]
  • Start date
C

Christoph Strobelt [Bt]

hi
i want to program a chart. but i got the error(1004) in the line .XValues =
xwerte. this error appears only when counter is 1.
can someone help me? is the array xwerte too big?
chris


Dim diagramm, counter, zähler, wert, n, xwerte(50), ywerte(50)
Dim diagrammobj

ActiveWorkbook.ActiveSheet.ChartObjects.Add(0, 0, 800, 900).Name =
"Diagramm"
Set diagramm =
Workbooks("Frequenz.xls").Worksheets("Motoren").ChartObjects(1)
Set diagrammobj =
Workbooks("Frequenz.xls").Worksheets("Motoren").ChartObjects(1).Chart
diagrammobj.ChartType = xlXYScatterLines
diagrammobj.SeriesCollection.NewSeries
diagrammobj.Axes(xlCategory).MaximumScale = 6000
diagrammobj.Axes(xlValue).MaximumScale = 2500

wert = 120

For counter = 0 To 1

If counter = 0 Then

For n = 0 To 50
xwerte(n) = n * 60
ywerte(n) = wert
Next

Else

For n = 0 To 50
xwerte(n) = (n + 51) * 60
ywerte(n) = wert
Next

End If

zähler = zähler + 1
diagrammobj.SeriesCollection.NewSeries

With diagrammobj.SeriesCollection(zähler)
.Border.ColorIndex = 3
.MarkerStyle = xlMarkerStyleSquare
.MarkerSize = 9
.XValues = xwerte
.Values = ywerte
End With

Next
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top