• 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...

  • 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

Stephan

Member
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.



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/clearly_and_simply/2009/08/build-your-own-choropleth-maps-with-excel.html
 

Attachments

Last edited:
Top