View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ahperez@gmail.com is offline
external usenet poster
 
Posts: 1
Default Cannot Activate Chart Area in Chart. Chart Object Failed

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