Thread: Cannot Activate Chart Area in Chart. Chart Object Failed
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tony Tony is offline
external usenet poster
  
Posts: 1
Default Cannot Activate Chart Area in Chart. Chart Object Failed
Thanks. I used your suggested code but now I am getting a 424 Object
required error.

'error here
With ActiveSheet.ChartObjects("WhatMatters").Chart.Plot Area
.SeriesCollection(1).XValues = "='" & managerDataSheet & "'!" &
graphXValueAddress
.SeriesCollection(1).Values = "='" & managerDataSheet & "'!" &
completeGraphAddress
End With

Thoughts?

Reply With QuoteReply With Quote