Sorting bars numerically using Crystal Chart Expert

[bessebo]

I have created a bar graph using the Chart Expert but want to be able to have the values in the bars sort numerically. In other words, I want the smallest bar to be on the left and the next highest to the right of that and the tallest bar furthest to the right. How can I have the bars sort in this numerical manner?

Thanks,
Bessebo

 

[kenhamady]

If this is a group chart, you can use the TopN to sort the groups in ascending order:

Sort ALL based on this subtotal.

this will not only put the groups of the report in order, but will also sort the bars. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[bessebo]

Ken,
I tried what you suggested with no results. The plot always wants to sort alphabetically by the name of the resolution code. The plot shows the distribution of the number of calls closed by resolution code as a bar chart. We want the bars to sort lowest to highest. I clicked on Report - TopN/Sort Group Expert and chose Sort All of Count of Call.Call_Num and chose ascending. The plot did not change at all.

The plot itself in the Chart Expert under the Data tab has the following:
On Change of "Call.Resolution - A" Show Value "Count of Call.Call_Num". I can send you a copy of the report by Saving Data with report if it would help.

Thanks,
Bessebo

 

[bessebo]

Ken,
Disregard last post... I got it to work...

Thanks,
Bessebo

 

[kenhamady]

what version of CR? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)