Forum Discussion
Marino Miccio
Mar 15, 2018Copper Contributor
Excel Bing Map Chart - Zoom on a Region
Hi,
I'm working with Map Charts with dynamic data filtered using a slicer, the map area in the series options is set on Automatic.
I want to force excel, also using VBA, to zoom on th...
SergeiBaklan
Mar 15, 2018Diamond Contributor
Hi Marino,
Did you try this setting?
- Marino MiccioMar 21, 2018Copper Contributor
Dear Sergei
thank you for your reply, I tried that selection but I do not want to hide region without data, this kind of representation in some cases give the effect to have countries as island.
My goal is to zoom automatically on a specific region depending on the data selection.
Regards,
Marino
- roy meijnemaMar 15, 2018Copper Contributor
Hi, I made a similar graph. I would like to put a link/buttom on my regular excel sheet to refer to this graph for users who are not familiar with the dataset. Is it possible to create this?
- Marino MiccioMar 21, 2018Copper Contributor
I roy,
you can insert a button, when you click on it the VBA code automatically change the worksheet and zoom also on your graph.
Marino