Thread: unable to set the values property of the series class
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ethoros Ethoros is offline
external usenet poster
  
Posts: 12
Default unable to set the values property of the series class
Try

ActiveChart.SeriesCollection(1).Formula = "=results!R4C4:R4C63"

instead of values

"BHatMJ" wrote:

I get this error message "unable to set the Values property of the Series
class" when trying to re-set a chart series to another range. Can anyone
help?

CODE:

Worksheets("analyze").ChartObjects("resChart").Act ivate
ActiveChart.ChartArea.Select
ActiveChart.SeriesCollection(1).Values = "=results!R4C4:R4C63"

Reply With QuoteReply With Quote