I have added a group (and color coding).

The chart is located in the Report header.

 

The sorting is not reacting as expected.  If I sort by group, sometimes it changes the chart sort, sometimes it doesn't.

Sometimes, it doesn't and then I change it to 'descending' and it sorts it 'ascending'!

I need it to sort by the grouping on the report (which has 3 separate levels of grouping) OR to sort based on the 'order by' in the stored procedure.  HELP!!!