legend sorting problem in bar chart.

[ub1234567]

hi everyone,

i am using bar chart in my report.

on x-axis i shows dollar amount 0 , 100k , 200k , 300k , 400k, 500k, 600k

on y-axis shows 4 items - Accesories , Bikes, clothing, components

i am also using legend which shows year.

on y-axis each item shows bar for each year dollar amount.

Example : for item Bikes year 2003 - amount 20k
2002 - amount 50k
2004 - amount 120k

so ultimately legend should display year like

2002 2003 2004 in ascending order.

but legends display year in order

2003 2002 2004

i already tryed 'on change field' year and item and set order for then one by one,
but it does not works.

this same kind of same problem occours in line chart too.

i think legend display years in the ascending order of dollar amount. - that is the problem.

any suggestion is appriciated.

thanks.

 

[Dan3D]

If all else fails, this problem can be solved with our CRChart add-in for Crystal Reports. There are specific macros to sort series and legend orders.

-Dan

DISCLAIMER: I work for the company, threedgraphics.com, that makes this product. This product costs money.

Dan Weingart
OEM Technical Manager
Three D Graphics, Inc.

http://www.threedgraphics.com