I have a Chart Web Part that is connected to a SharePoint list. I modified the All Items default view of the list so that it would be sorted correctly but the Chart Web Part does not pickup on the sort order. I've also looked through all of the properties of the Chart Web Part and cannot figure out how to set a sort order.
For example, my list looks something like this:
Name Value Bob 9 Jim 6 Sally 4 Richard 3
Yet the X axis of the bar chart is ordered like Sally, Jim, Richard, Bob even though the list's sort order is based on the number value.
How do you edit the sort order of the X axis of a Chart Web Part based on the Y axis value?