Macro to create a Powerview in Excel

[leftywydra]

I have Country, City, and State columns and a numeric column in an excel table that I would like to have displayed on a map in PowerView. Is there way to create a macro to automatically create this view?

 

[scottsen]

I am 98.8% sure you can not in current versions of Excel

 

[leftywydra]

I was really hoping the answer would be different, but when I tried to record a macro it appeared that I was out of luck. Thank you for the reply.