Chart highest to lowest, left to right 1

[McChops]

CR10

I have a bar chart which shows the number of records logged by location.

I want to configure the graph to show the location with the higest number of records logged on the left and the lowest on the right.

Please see thread thread149-1265140 for a similiar unsolved issue.

 

[lbass]

You need to select the chart->chart expert->select the "on change of" field->topN, choose "All", Descending.

-LB

 

[McChops]

lbass,

This will just sort the locations alphabetically as in the mentioned thread.

I would like the graph to have the location with the highest number of records on the left (this is a group summary / distinct count on number of records) descending to the location with the lowest on the right.

Thanks

 

[lbass]

No, that is not true. The topN sort within the chart expert will sort by the summary field. Please try it.

-LB

 

[McChops]

I take it all back lbass. Right you are. Thanks.