VBA- SeriesCollection

  • Thread starter Thread starter yusoon
  • Start date Start date
Y

yusoon

This code gives me run-time error : '438' object doesn't support thi
property or method

Worksheets("sheet1").ChartObjects("Chart 1").Chart. _
SeriesCollection(1).Value = "=Sheet1!R1C1:R20C1
 
It is really simple:
Worksheets("sheet1").ChartObjects("Chart 1").Chart. _
SeriesCollection(1).Values = "=Sheet1!R1C1:R20C1"

The s at value --> values is missing

Regards
Klaus
 

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

Similar Threads

VBA- SeriesCollection(1).Value error 3
.Seriescolection(n).formula - size limitation? 5
How to add series to a chart using a macro 12
chart series: displaying the source range 1
Range Selection & XValues in Chart 4
Chart DataLabel Placement Error 2
Change Colors in Charts 5
Problem programming .SeriesCollection().XValues and .Values 7

Back
Top