ArcGIS Pro

10 Tips for Tables on Layouts

Tables are a powerful way to share information on an ArcGIS Pro layout. And table frames on a layout support a lot of formatting options. Actually, there are so many formatting options it can be hard to remember them all! So here are my 10 Tricks for Tables on Layouts (trying saying that 10 times fast…).

1. Field vs. Frame

First, it is important to understand the difference between a table frame and table frame fields. The table frame is the layout container for the table data, just like a map frame is the layout container for a map. The table frame fields are the individual fields in the table, displayed in the table as columns.

Some properties belong to the table, for example controlling if all the data is displayed or just data visible in the map frame. Other properties are set at the field level, like using word wrapping to determine how wide a field is. By default, all fields in the table have the same properties, but you can edit the properties for individual fields. For example, you can make the first field in your table have a blue background and all the others have a gray background.

To access the properties for the table frame, select it in the Contents Pane, right click, and choose Properties. To access the properties for table frame fields, select one or more in the Contents Pane and do the same.

The Contents pane with the table frame and table fields highlighted

2. Add, Remove, and Reorder Fields

You can add, remove, and reorder fields in the table frame directly the Contents Pane. By default, only the first 10 fields are added to a table frame, so knowing how to add and remove fields is incredibly helpful.

Animated gif showing adding, removing, and reordering fields

3. Table Striping

Change the backgrounds for alternating rows to help your table data pop. In the table properties you can set 1 or 2 different row backgrounds and choose how many consecutive rows that background appears on. There are a lot of possible combinations!

4 examples of tables with stripes.
Table 1 uses the same formatting for all row backgrounds. Table 2 uses one row background on every other row. Table 3 uses two row backgrounds, with a one row – two rows pattern. Table 4 uses one row background on every two rows.

4. Number Formatting

Numbers in your table reflect the number formatting settings in the table fields view. You can adjust the number settings to show the numbers as currency, percentages, and more. You can also control the number of decimal places and whether a thousand separator is shown.

A table with 6 text fields showing different text formatting options
Every numeric field in this table has some sort of number formatting set. Total Population and Total Household fields have the thousand separators turned on. Average Household Size is limited to 2 decimals and padded with zeros. Median Household Income and Median Home value are both shown as currency, and Unemployment Rate is show as a percentage.

5. Sorting

You can sort the table based on any field included in the table frame. For text fields the sorting is alphabetical, for numeric fields it’s numeric. And date fields are sorted by date. Multiple fields can be used for sorting too!

A table with 3 fields, the table is sorted based on the third field
This table is sorted based on the third field, Date.

6. Alignment

You can set the alignment for individual table frame fields. Sometimes I like to have my text fields aligned to the left and my numeric fields aligned to the right. That can be done by selecting the field you want to align, changing the dropdown to Data text (so that only the field text is modified, not the heading) and setting the alignment.

A table with 3 fields. The first 2 fields are left aligned, the third is right aligned
In this table frame the Year and City fields are left aligned, while the Athletes field is right aligned. The controls for changing the Athlete alignment are highlighted.

7. Gaps

Tables will automatically wrap to new columns if the data is too long (if you want to switch this behavior check out the table frame fitting strategies). You can change the gap between these columns, as well as other gaps in the table. If you want to make your table more compact, try decreasing gap sizes. Just don’t forget, gaps are properties of the table frame, not the table frame fields!

A table with 2 table columns separated by a narrow gap. The gap controls in the Element pane are shown and highlighted
This table uses a narrow frame gap to fit in the allocated space.

8. Use Definition Queries

Displaying all spatial features in a table can get really long. Consider creating a duplicate invisible layer or a standalone table and adding a definition query on it to display only the most important features in a table.

A layout with a map frame, legend, text, and table. The table displays fewer rows than points on the map.
This map shows 837 power plants, way too many for a table on the layout. So, I exported the features to a standalone table and used a definition query on capacity to get only the 10 largest power plants. I then used that data to create the table frame.

9. Quickly Update Fonts

There are a lot of places to set text properties for tables. You can have different text properties for each field if you’d like! Or just different for headings and text. Or just for one field. You decide… However, I often find myself just needing to quickly update the font or text color for all the text in my table. Instead of poking through the pane, in this case I can just use the Format tab on the ribbon. Font settings updated there will be applied to all the text in the table.

The font controls on the Format table for a selected Table Frame. The size control is blank because my table has different sized text for headings and data text. I don’t usually update the text size in the ribbon, just the font and color.

10. Table Frame vs Table Dynamic Text

Sometimes, a table is not the right fit. If you can’t get your table to look the way you want, or you don’t want to display the headings, consider using table dynamic text instead. Table dynamic text reads values from a table in your map and displays them as text. If those values are updated, the text is automatically updated (that’s why it’s called dynamic). Table dynamic text supports custom queries to determine what data is shown, and Arcade expressions to format the displayed text.

If a table just isn’t working, dynamic table text might do the trick.

Image 1 is displaying 3 fields using table dynamic text with an Arcade expression. This allows for dots and commas to separate fields instead of requiring a new column. Image 2 is displaying that same information as a table.
Image 1 is displaying 3 fields using table dynamic text with an Arcade expression. This allows for dots and commas to separate fields instead of requiring a new column. Image 2 is displaying that same information as a table. Note: Getting dots to display in the dynamic table text requires a more advanced Arcade expression and some luck, the data doesn’t always align nicely due to the various character sizes in the text.

There you have it! 10 tricks for tables in layout. Have fun creating your own table frames on your next layout!!

About the author

I love good cartography, good burritos, and helping people figure out effective ways to share their data with others. Luckily, my work as a Product Engineer on the ArcGIS Pro Layout team lets me do that everyday.

Connect:
0 Comments
Inline Feedbacks
View all comments

Next Article

How 8 Million+ Census 2020 Features were Hosted to ArcGIS Living Atlas

Read this article