Error when trying to access data for RegionMap chart type

[mbraun]

Excel macro that loops through slides of a PowerPoint presentation and changes the data for numerous charts.


Macro works perfectly fine until it comes across a shape where .Chart.ChartType=xlRegionMap


Code where I get the error:

Set wbk = Sh.Chart.ChartData.Workbook


Again, this line works fine for every other type of chart except a region map. Anyone know why this is, and have a workaround?


Any help is much appreciated!

[Andy Pope]

Have you tried activating the chartdata first?



Sh.Chart.ChartData.activate
Set wbk = Sh.Chart.ChartData.Workbook

[MuriceHunte]

Have you tried activating the chartdata first?

tunnel rush (https://tunnelrush3.com)


Sh.Chart.ChartData.activate
Set wbk = Sh.Chart.ChartData.Workbook



Can you explain this part specifically?

[Andy Pope]

On a standard chart this would activate the data sheet, where the values are stored