+ Reply to Thread
Results 1 to 4 of 4

Custom map chart with slicer connected

  1. #1
    Registered User
    Join Date
    02-11-2022
    Location
    Croatia
    MS-Off Ver
    2021 Professional Plus
    Posts
    2

    Custom map chart with slicer connected

    Hello,

    I am trying to create a custom map of my country in Excel, with several regions that could be highlighted when selected via slicer. I can provide a link of the map (not sure if it is allowed) where it is visible how it should basically work, but I don't know if it is possible to create something like that in Excel.

    Any help is much appreciated,

    Thank you in advance!

    p.s. greetings to the forum!

  2. #2
    Registered User
    Join Date
    01-19-2022
    Location
    Alaska, USA
    MS-Off Ver
    2013
    Posts
    13

    Re: Custom map chart with slicer connected

    Follow these steps,

    1- Prepare the data in a pivot table
    2- Connect the pivot table with Excel Map data input
    3- Insert slicers to create interactive dashboard with a map

    Next choose Insert tab > Filters > Slicer and choose the fields to become filters for your dashboard. If your data contains date columns in the proper format and you are running Excel 2013+, you could also insert a timeline slicer, which is great to filter years and months.


    (You can add more tables and charts by copying the existing pivot table this way your slicers will be automatically connected to all new pivot objects (tables and charts). For example, you could create a pivot table showing Top 10 of your customers and turn it into a bar chart.)
    Last edited by AliGW; 02-13-2022 at 08:57 AM. Reason: PLEASE don't quote unnecessarily!

  3. #3
    Registered User
    Join Date
    02-11-2022
    Location
    Croatia
    MS-Off Ver
    2021 Professional Plus
    Posts
    2

    Re: Custom map chart with slicer connected

    Thanks for the reply!

    I am not sure if you can connect a Pivot table to a Map function. It gets back: "You can't create this chart type with data inside a Pivot table..."

    The problem with a filled map chart in my case is that Excel recognizes easily states in U.S., Australia etc, but does not recognize regions in "other" countries, Croatia in this example, so I am trying to find a way to create such a map, a filled map chart to be more precise.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,016

    Re: Custom map chart with slicer connected

    Microsoft can be very English-speaking-world-centric at times! I am not sure that you will be able to do what you want natively in Excel. It may be possible with VBA - I can move this thread if necessary.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] how to create a chart connected with slicer
    By emmr in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-20-2021, 02:50 AM
  2. Detect changes to slicer filters for slicers connected to a table
    By jmwbowen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2020, 09:44 AM
  3. Replies: 0
    Last Post: 10-19-2019, 03:32 PM
  4. Replies: 1
    Last Post: 04-23-2018, 09:43 AM
  5. changing data source for all tables connected with slicer
    By ScottLor in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-14-2017, 08:56 AM
  6. how many pivot table can be connected to a single slicer?
    By vishnu01445 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-28-2016, 05:35 AM
  7. [SOLVED] Change Chart Title Depending on a Slicer - slicer advice
    By JungleJme in forum Excel General
    Replies: 8
    Last Post: 08-17-2012, 07:59 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1