1 min read

Excel is how I do maps…

Following the footsteps of this cool post I saw by JohnNelsonIDV, I wanted to try to and make a map using Excel.

Fast forward 2 days and the opportunity came up. Lo and behold, a Map of Reference Evapotranspiration built in Excel!

ET0

Instructions:

  1. Read data file into Excel (skip top rows with metadata), make sure to delimit correctly so that each value is in a column.
  2. Select ALL cells (Ctrl+A twice)
  3. Make column width same as row width
  4. With all selected, add a conditional formatting based on value.

Download the whole excel file here:

 Reference Evapotranspiration Map «

Based on FAO data