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 co...