Rich table formatting in ArcMap
The default, plain, way
Embedding a table in an Arcmap layout has been around since its inception, and it’s pretty easy, though the menu item for making it happen is buried so many don’t know about it: Open the attribute table that you want to create the report from, click the Options button on the bottom of the Attribute table window, and select the option to “Add Table to Layout“. (An expanded treatment of this method can be found at Using tables in an ArcMap layout on one of the the Esri blogs.)
Adding some style!
This is good and useful, but what if you want some more control over how it looks? A little bit more work, but not too bad and well worth it: copy the table to Excel and do the pretty stuff there.
- Open the attribute table >> select the records of interest >> r-click on the row selector at far left >> Copy selected records
- Open Excel >> Paste
- Apply Styles and format conditionally as is your wont (To lose the jail cells, fill the background with a pure colour)
- Now reverse the process and copy and paste back to Arcmap, then size place to suit.
et Voila!
Limitations
The table is just a dumb graphic. If you see a spelling mistake or need to udpate it for next year you’ll need to repeat everything (but that’s the same for the native Arcmap embedded tables). To make repeated updates easier, export rather than copy the table (saving results in a model for quick repeat), and use saved styles and formatting rules everywhere possible in Excel.
End notes
Also see Adding simple table of text (Excel) into layout and preserving formatting and clarity? on GIS Stack Exchange which adds some details and discusses other approaches.
The graphics used to illustrate the technique were used in the Human-Bear Conflict map series which summarized incidents of human-bear conflicts in Whitehorse and Southern Lakes during the summers of 2012 through 2014. See http://www.env.gov.yk.ca/maps. This post is not affiliated with or endorsed by Environment Yukon (the map publisher and my employer).