How to Make Heatmap in Excel ArcGIS Add In

#excel #arcgis #arcgisforexcel #howto
Just a simple video showing you how to create a heatmap in ArcGIS for Excel.
This video is just a blog and does not represent anyone other than myself.

Steps to Create a Heat Map Using ArcGIS for Excel
Introduction (0:00 - 0:05)

Brief overview of what will be covered in the video.
Prepare Your Data and Layers (0:06 - 0:30)

Ensure your Excel sheet has the data ready.
Add a layer with the location points.
Creating a Heat Map (0:31 - 0:45)

Select the layer and choose to display it as a heat map.
Compare the difference between location points and the heat map view.
Adjusting Color Ramp (0:46 - 1:20)

Access the color palette to pick your preferred color ramp.
Options include "red hot, blue cold" or other combinations like "purple and gold."
Modify the colors to highlight high and low areas effectively.
Modifying Heat Map Settings (1:21 - 1:50)

Adjust the blur radius for a more concentrated or dispersed heat map.
Tweak the settings to ensure the heat map visibility aligns with your data needs.
Layer Visibility and Properties (1:51 - 3:15)

Toggle between different layers to show or hide them as needed.
Zoom in to see detailed points, zoom out to see the heat map.
Change layer visibility properties to manage when layers become visible.
Set the visible range to control at what zoom levels the heat map and points appear.
Using Heat Maps for Data Exploration (3:16 - 3:30)

Utilize heat maps to identify pockets of activity.
Investigate specific areas highlighted by the heat map to find detailed incidents or data points.

[MicahJohns]

Steps to Create a Heat Map Using ArcGIS for Excel
Introduction (0:00 - 0:05)

Brief overview of what will be covered in the video.
Prepare Your Data and Layers (0:06 - 0:30)

Ensure your Excel sheet has the data ready.
Add a layer with the location points.
Creating a Heat Map (0:31 - 0:45)

Select the layer and choose to display it as a heat map.
Compare the difference between location points and the heat map view.
Adjusting Color Ramp (0:46 - 1:20)

Access the color palette to pick your preferred color ramp.
Options include "red hot, blue cold" or other combinations like "purple and gold."
Modify the colors to highlight high and low areas effectively.
Modifying Heat Map Settings (1:21 - 1:50)

Adjust the blur radius for a more concentrated or dispersed heat map.
Tweak the settings to ensure the heat map visibility aligns with your data needs.
Layer Visibility and Properties (1:51 - 3:15)

Toggle between different layers to show or hide them as needed.
Zoom in to see detailed points, zoom out to see the heat map.
Change layer visibility properties to manage when layers become visible.
Set the visible range to control at what zoom levels the heat map and points appear.
Using Heat Maps for Data Exploration (3:16 - 3:30)

Utilize heat maps to identify pockets of activity.
Investigate specific areas highlighted by the heat map to find detailed incidents or data points.