Bar Chart — Set min/max x-axis bounds using calculated/sysdate values; fill in gaps with empty bars

Bud — Sat, 25 Mar 2023 18:38:34 GMT

I have a FGDB table that I'll use to make a bar chart:

     YEAR_     AMOUNT
---------- ----------
      2024        100
      2025        200
      2025        300
      2026        400
      2027        500
      2028        600
      2028        700
      2028        800
      2029        900
      2031        100

That bar chart works, but I need bars in the bar chart for each year within a range: system year + 9.
In other words, I want bars for 10 years, starting with the current year (currently 2023).

But in ArcGIS Pro 3.0.3, I can't control the x-axis bounds:

Ideally, I'd be able to set the x-axis min and max bounds using calculated values:

Min: EXTRACT(YEAR from SYSDATE) = 2023
Max: EXTRACT(YEAR from SYSDATE) + 9 = 2032

The x-axis would have bars for all years in that range: 2023, 2024, 2025, 2026, 2027, 2028, 2029, 2030, 2031, 2032. You'll notice that 2023, 2030, and 2032 were missing from the data, but were added due to the range.

It would look like this:

The x-axis bounds would be dynamic. So on January 1, 2024, the chart would automatically switch from 2023-2032 to 2024-2033.
To be clear, I don't want to manually add filler rows to the table or export a copy of the table for modifying the data. I want dynamic bounds in the chart.
It's important to note that all gaps need to be filled; the chart wouldn't look right if there was a gap for 2023, 2030, or 2032.
I suppose the programming language for the calculated values would be Arcade.

Could that functionality be added to ArcGIS Pro?

Re: Bar Chart — Set min/max x-axis bounds using calculated values; fill in gaps with empty bars - Status changed to: Under Consideration

ChristopherAllen — Fri, 24 Mar 2023 19:50:01 GMT

idea Bar Chart — Set min/max x-axis bounds using calculated/sysdate values; fill in gaps with empty bars in ArcGIS Pro Ideas

Bar Chart — Set min/max x-axis bounds using calculated/sysdate values; fill in gaps with empty bars

Re: Bar Chart — Set min/max x-axis bounds using calculated values; fill in gaps with empty bars - Status changed to: Under Consideration