1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

UK HeatMap Combo + Rank ScrollBar Dynamic Charts

Discussion in 'Excel Dashboards' started by Stephan, Mar 20, 2017.

  1. Stephan

    Stephan Member

    Messages:
    55
    UK HeatMap amalgamated with Dynamic Charts/Gauges via Scroll Bars:

    Scroll Bar spinners > Top Right below Gauges. ComboBox > B2.

    Data is made up, hence not real or true, they are fictitious, just for example.

    Q: Free sources of SVG image files of UK/GB/ENGLAND with complete ID3 & AutoShape Cities / Counties???

    Many seem incomplete either without individual naming of county/city autoshape segments, or just won't ungroup in XL. Hence without specific SVG image that is complete, will prevent from starting HeatMap as wouldn't match dataset categories.

    [​IMG]

    SVG image files can be in opened in XL as XML to copy City/Column ID3 code, then converted with InkScape to EMF for inserting into XL then rename generic AutoShape names to specific city/county using this macro:

    http://www.clearlyandsimply.com/cle...uild-your-own-choropleth-maps-with-excel.html

    Attached Files:

    Last edited: Mar 20, 2017

Share This Page