Skip to Content
0
Former Member
Feb 10, 2012 at 08:59 PM

Method for sorting of a legend

17 Views

I am using CR8.5 and CR2008. There are a few reports with line charts for the years with the data points at each month. Sometimes the legend for the chart is not ordered. In my research to find why the legend sometimes sorts and sometimes doesn't, I found that if the first data point has a value, those years are ordered first. As more years have data points later in the chart, I find that they are ordered below.

Example:

Jan-2008: 100

Feb-2008: 150

Mar-2008: 125

Jan-2009: 105

Feb-2009: 155

Mar-2009: 120

Jan-2010: 100

Feb-2010: 150

Mar-2010: 125

The legend is ordered as 2008, 2009, 2010.

Feb-2008: 150

Mar-2008: 125

Jan-2009: 105

Feb-2009: 155

Mar-2009: 120

Jan-2010: 100

Feb-2010: 150

Mar-2010: 125

The chart above would have the legend showing as 2009, 2010, 2008.

Although as a user I don't like this logic, does this seem to be a problem? If it is has a solution been provided?

Thank you,

Jim