COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: krishdw85 on 24 Sep 2015 08:53:57 AM

Title: Legend Chart sorting issue
Post by: krishdw85 on 24 Sep 2015 08:53:57 AM
Hi Team,

How to control the sorting order of legend. Here i have 3 diff measures in the chart. By default Bar chart one is coming first and rest line is second & third. But my order should be reverse . New cases, completed cases & Avg TAT. If i make all the measures as line chart then it is coming properly but here Avg TAT should be Bar.
Please advive.
Title: Re: Legend Chart sorting issue
Post by: krishdw85 on 28 Sep 2015 01:19:02 AM
Any inputs guys...
Title: Re: Legend Chart sorting issue
Post by: ToriBurns on 28 Sep 2015 03:13:14 AM
Hi krishdw85,

If you are using a combination chart, select the chart and on properties, navigate to Combinations property under General. Click on the ellipsis, then you can change the order of your legend or series on the dialog box that will appear. Please see attached image for your reference. Not sure if this will solve your problem. Hope it helps.

Cheers! :)
Tori
Title: Re: Legend Chart sorting issue
Post by: krishdw85 on 28 Sep 2015 07:14:45 AM
Hi, i am not using legacy charts.... bcoz it has some limitations.
Actaully sorting is cmg fine in html output , only in excel output it is coming different
Title: Re: Legend Chart sorting issue
Post by: krishdw85 on 28 Sep 2015 07:51:53 AM
Attached outputs for your reference. Need the order same as HTML
Title: Re: Legend Chart sorting issue
Post by: ToriBurns on 28 Sep 2015 09:44:12 PM
What are you using? What do you see on the properties of the chart? Did you try my suggestion?

Thanks and regards,
Tori :)
Title: Re: Legend Chart sorting issue
Post by: krishdw85 on 29 Sep 2015 01:15:50 AM
i tried to follow your suggestion but i dont see those options i am using cognos 10.1.1
Title: Re: Legend Chart sorting issue
Post by: ToriBurns on 29 Sep 2015 02:16:33 AM
I guess your package is dimensional. Not sure though why the order/sorting of your legend is different when run on excel.

Cheers!
Tori
Title: Re: Legend Chart sorting issue
Post by: krishdw85 on 29 Sep 2015 02:28:27 AM
my package is relational only.....it is simple chart with 3 measures and one time dimesion. Out of 3 measures 2 line & 1 bar. In Excel by defult Bar chart data item name is coming first though it is placed last. In HTML it is cmg as expected.
Title: Re: Legend Chart sorting issue
Post by: ToriBurns on 29 Sep 2015 02:54:10 AM
Hi krishdw85,

Can you please check under Tools > Options > Advanced if "Use legacy chart authoring" and "Override 10.x styles on new reports" is checked? If so, please uncheck it. Try to recreate your chart. You would noticed a difference. Select combination chart or column chart. Select the chart and you would see on properties the combinations under general. Fix the order there. I tried this and my excel is showing the same output as the html. This is just a suggestion. Not sure if this will work for you. Hope it helps.

Cheers!
Tori :)
Title: Re: Legend Chart sorting issue
Post by: krishdw85 on 29 Sep 2015 05:14:02 AM
Yeah i tried same... but it is not working.
Appreciate for your help. PFA output....unchecked the option and created a new combination chart .