I am working to update the series source in a chart. I have an excel
template in which I copy 2 worksheets into my workbook.

I would like to edit one chart using my VBA code. I am getting Method
PlotArea of Object '_Chart' Failed.

The code is below.

Thanks for your help.

Sheets(1).Select
ActiveSheet.ChartObjects("WhatMatters").Activate
ActiveChart.PlotArea.Select

1. If the chart has no data to plot, there may not be a plot area to select.

2. Don't keep selecting all the objects. It will be faster and less
distracting this way:

With ActiveSheet.ChartObjects("WhatMatters").Chart.PlotArea
' do whatever to the plot area
End With

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I am working to update the series source in a chart. I have an excel
> template in which I copy 2 worksheets into my workbook.
>
> I would like to edit one chart using my VBA code. I am getting Method
> PlotArea of Object '_Chart' Failed.
>
> The code is below.
>
> Thanks for your help.
>
> Sheets(1).Select
> ActiveSheet.ChartObjects("WhatMatters").Activate
> ActiveChart.PlotArea.Select
>

Thanks. I used your suggested code but now I am getting a 424 Object
required error.

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

Thoughts?