How to change Gradient colors in U.S. State Heat Map Excel Template?
[vc_row][vc_column][vc_column_text]
[/vc_column_text][vc_column_text]
Page Contents
HOW TO CHANGE GRADIENT COLORS
VIDEO DEMO
1. Open the Conditional formatting menu in Home ribbon and choose ‘Manage Rules’.
2. Choose the sheet: Map
3. Select the Gradient Color Scale rule and then click Edit Rule.
4. Change the colors (for minimum, midpoint and maximum) as needed.
If you are familiar with Excel, you can use other conditional formatting rules and settings too. For example, you can also choose the format style be 2-Color Scale instead of the 3-Color Scale.
That will change the map visualization to appear like this.
Whenever you change colors, please update the NOTE so that the footnote that appears on the map aligns with the color rule applied.
If you have any questions, please leave them in the comments below.[/vc_column_text][/vc_column][/vc_row]
Leave a Reply