Map chart - VBA code to automatically select color properties

Hi,

I want to automatically switch the select color properties of the Map Chart series between "numeric value" and "secondary category names".

I tried also recording a macro but the VBA code seems not working.

The recorded code is the following:

Sheets("DASHBOARD").ChartObjects("Chart 13").Activate

ActiveChart.FullSeriesCollection(1).DataLabels.Select
Application.CutCopyMode = False

 

Any idea?

Thanks for the support,

regards,

Marino