The “average” aggregation is not currently available for Formula Custom Fields in the Y-axis of Bar Chart cards. This is a known limitation, and there is no workaround to display the average of a Formula field in a Bar Chart card at this time.