Pivot Table Chart Style in ArcGIS Pro
In some map products I've been making, I'm required to include relatively simple statistics in the map legend (i.e. SUM of feature areas by Category). I've had a look at the Dynamic Text option which can SUM values for a field (almost does the trick), but as I'm using the Shape_Area value to get dynamic areas, they're recorded in square metres. I'm wanting to display the figures as Hecatares. In the Attribute tables, this is easy done using the Rate format with a value of 10,000, but this doesn't flow through to the Dynamic Text (still sums in m2). Instead I'm using the Bar Chart option to display the numbers, though really it doesn't need the "Chart" element, just the category and numbers (like in a pivot table). This method does honour the formatted values to show Hectares instead of m2.
Instead of this;
Display this;
Options could include colouring the columns as per the Category (like in the Bar Chart), having a Total Column on the end, wrapping the Category labels like in my image, number formatting, etc.
