What is the Best way to Sort data for the following Scenario

[#1]

I have Large number of Credit Card Transaction. Approximately 50,000 Transaction in one month

Some spend less than 100,  some spend 20,000

I  want to show the number of users and total amount spend by the users in chart.

So I am creating two charts instead of one.

CHART 1  will have x dimesnion= Amount Spend, Y dimension = Count of Users

CHART 2 will have X dimension= Amount Spend, Y dimension = Sum of amount

For X Axis I am using a Class function to form a Range.

FInal chart is displayed as follows

My Issue is

I want user to compare top and bottom chart. I want to maintain consistent sort for X Axis. So that user can compare

example X axis should sort as follows 0-42, 42-84, 84-126, 126-169, 168-210

Similarly for Y axis

Basically I want sort based on X axis instead of Y Axis

1. How do I sort?

2. Is there any better way to show the chart?

Thank you

[Gysbert_Wassenaar · Accepted solution]

Sort both charts the same way by enabling numerical sort for the class dimension