[BUG]: X-Axis NULL values lead to typeError when using categoryorder sumdescending in barcharts #7840

Description

When using the ordercategory "sum descending" in a barchart that has a NULL X-Value follow error occures:
"TypeError: Cannot read properties of undefined (reading '1')".

Steps to reproduce

Code here

• One or more traces required
• If null is replaced with a string value, it works
• Codepen unfortunately does not show the error in the console.
• In case of an error, nothing is shown at all

Notes

• I did not try it for all categoryorders but it looks like it does not work for all orders that require calculations. (e.g. total descending)