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