I think what you need to do is calculate the y-axis aggregate values in the dataset query using SQL or as a calculated field in the dataset. That way you can leverage the y-axis value for the sorting and grouping of the rows in the data and thus control the paging of the bar chart also.