Forum Discussion
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 the area where data are not null.
In the attached case the map is not zoomed on the entire Europe because Turkey and Israel are considered as european countries.
If I set them in the Middle East region I only shift the problem there.
Do you have any suggestion to fully visualize the desired region?
Is there the possibility to utilize VBA code to force the map area?
Thank you in advance for any clarifiaction.
Marino
4 Replies
Hi Marino,
Did you try this setting?
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
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?
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
