Create tabular labels with multiple attribute fields

4987
21
04-03-2011 05:35 PM
Status: Under Consideration
Labels (1)
MarcBate1
Occasional Contributor
Please add support for tabular labels that show multiple fields and support row/column totals and formatting similar to those available in Excel 2010.

These should provide the following options when choosing the feature class attribute fields to use for the tables:
  • Transpose tables (fields across left instead of top)
  • Calculated fields - expressions using other field attribute values
  • Formatting similar to those available in Excel for tables including cell shading, borders.  Each field used would be assigned a style gallery item so the header cells or total columns could be easily configured. There could be a new Table Labels style class that saves this configuration of all the styles similar to the legend styles.  The Table Styles under the Excel 2010 ribbon would be a good thing to follow, where you can easily set the 'Table Style Options' such as Header Row, Banded Rows, Total Row, etc. 

0EM30000000Cnw7

  • Support automatic creation and styling of row and column totals
  • Allow for what would otherwise be multiple tables with just 1 label per feature to be grouped so if there are multiple dates in the feature class for example, you'll get multiple rows in your table, i.e. define a row grouping field
  • Support converting these labels to annotation via ArcMap UI as well as a geoprocessing tool to convert the labels to annotation, but that's really another new request
Here's an example markup using Excel 2010 tables that were copied and pasted into Layout view as EMF images and grouped with callout symbols whose text was empty and rectangle is under the tables.

0EM30000000Cnw2
*Each label here would actually be coming from a different feature class, so for each feature class, all the tables would look the same of course.
21 Comments
JimThomas
This is a great idea.  IThe closest I've been able to get to crosstab tables in ArcGIS is by using an interface created by Earthsoft and EnviroInsite.  The results get tabulated and very crude annotation is created and copied into the data frame as text and shapes.  If ArcGIS had the functionality to include row/columns in the label, we would be able to get closer to our dream of having a true table as a label.  On a related note, I would like the functionality to label based on related tables.  EXAMPLE:  label one location with mulitple laboratory results (many to one relationship).

Thanks!
CameronWallace
This should really be considered in conjuction with this idea: https://c.na9.visual.force.com/apex/ideaView?id=087E00000004Dv8IAE

A
nyone come across any decent work-arounds that can be automated? (i.e. please... no more manual excel insertion)
CameronWallace
Any activity on this? ESRI?
CameronWallace
Any activity on this? ESRI?
CameronWallace
Hmmm... might be time to look at the open source options... 
http://planet.qgis.org/planet/tag/2.0/ 
AndrewBrown16
Any updates, ESRI? This is a great idea that should be implemented.

I have an ArcMap plugin that creates tables via Excel Interop and pastes the formatted tables as images into ArcMap, but they're images and don't have a leaderline. If I were to create fully customizable tables with leaderlines, that would be amazing. 
CameronWallace
Inserting excel tables into my layout just about kills me... some implementation of this is really overdue. Preferably feature linked annotation based on related tables... or html formatting allowed in label expressions or... something that actually allows linework to be drawn between the cells, and formatting of the data, and updates.
SolanaFoo2

Yes please

KevinBrown10

This would be super valuable and amazing!

KoryKramer

Thank you for the comment @KevinBrown10    I took a look and it doesn't appear that you added your kudos to the idea (maybe you have in the past, but I didn't see one recently). While comments are important, kudos (the number of votes) that an idea receives is one of the primary pieces of data that we use to determine traction and trends as we monitor idea activity over time.

Please see https://community.esri.com/t5/custom/page/page-id/arcgis-ideas for a high level overview of how ArcGIS Ideas works. For more details, see Frequently Asked Questions about ArcGIS Ideas 

Thank you for your participation in the community and for helping us prioritize future development efforts for ArcGIS Pro.