Dashboard Geo/Heatmaps from XL Data

[Stephan]

Hello, attached Dashboard for Dynamic Charts and Interactive Geo/Heatmaps from XL data. Questions welcome!

Combo Box to see Dynamic Charts: 1st tab cell O3

Geo Map link: 1st tab cell O7
or
Heatmap link: 1st tab cell O11

Or here is my Geo/Heatmap examples, from real industry staff data per region uk:https://fusiontables.googleusercont...=1&z=5&l=col2&y=2&tmplt=2&hml=ONE_COL_LAT_LNGGEO MAP UK:

HEATMAP UK:

PRINT SCREEN XL DASHBOARD:

Also has security feature, see P26 & P28 on 1st tab, blank this and data blank.

Excel > online Map. Make your own, this is the best free solution: https://fusiontables.google.com/

"If" your XL table is arranged the opposite way, simple way to rearrange:
Copy table: Edit, Paste Special, Transpose.

 

[Stephan]

Newest version now with Dynamic Images & Gauges + Charts.

1st tab combo box: P4 & P9.
2nd tab combox boxes: R5, R10 & R20.

File useful, see how to do your own! Inspiration comes less easily from blank pages, or incomplete examples! All done in Excel 2003, all Formulas, no Macros. Formulas are mostly Countif, Index, Match, Sumif, Sumproduct, Defined Names & Validation Combo boxes.