A question about formatting a chart, VBA, Chapter 15, Page 316

[Virgin]

I tried changing the interior color of the following chart:
Workbook: "ProjectFilesChapter15-FirstChart.xlsm"
Worksheet: "Sheet1"

I used the following line:
Workbooks("ProjectFilesChapter15-FirstChart.xlsm").Activate
Worksheets("Sheet1").Shapes("Chart 2").Chart.Interior.Color = RGB(0,255,0)

I receive Run Tim Error 438

Thank you!

 

[RoryA]

A chart doesn't have an Interior property. It should be:

Worksheets("Sheet1").Shapes("Chart 2").Chart.ChartArea.Interior.Color = RGB(0,255,0)

if you are trying to change the chart background colour, or use PlotArea if you only want the plot area.