How to filter a card-diagramm by klicking on the countries in the map?

Rene Bluemke 0 Reputation points
2023-03-28T07:59:53.52+00:00

Good morning,

i have a problem with my card-diagram (map) in excel.
I've got some slicers to visualize the diagramm in different colours etc.

I can filter the shown countries in the map by klicking on the countries in the slicers.

Now i want to klick on the countries in the map to filter the countries in the slicers.

Is that possible by writing a function with VBA?

PS: I'm a newbie in VBA and Makros.

Greets,

Rene Blümke

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,450 questions
Windows Maps
Windows Maps
A Microsoft app that provides voice navigation and turn-by-turn driving, transit, and walking directions.
245 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,473 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. IoTGirl 2,976 Reputation points Microsoft Employee
    2023-04-03T18:46:24.44+00:00

    Hi Rene, I assume you are doing this https://support.microsoft.com/en-us/office/create-a-map-chart-in-excel-f2cfed55-d622-42cd-8ec9-ec8a358b593b. I am not familiar with the term "card-diagram". Can you please clarify what you are doing? Maybe provide some simple steps for us to see your issue? Sincerely, IoTGirl

    0 comments