Hello!
I am trying to match the sequence of a series in a stacked graph with the way the series are shown in the legend. For some reason I cannot figure out, the stacked graph always shows the data in reverse sequence compared to the legend sequence. I have tried sorting the series in asc, desc order and no luck...always the reverse order is shown in the graph compared to the legend.
In the attached example, you can see what I am encountering. I would like the way the first column in the graph, for example, to appear in the same order as shown in the legend.
Is there a way to force the graph to present the series in the same sequence as they appear in the legend?
I've snooped around the javascript that controls the stacked charts. The chart paints the categories bottom up, and the legend top down. As far as it's concerned, the legend is in order. I haven't had a chance yet to really start hacking the chart, but I did think of an annoying workaround.
The workaround is long, and only works if you have a finite number of series. I do not believe it is worth the effort, but here you go:
- ensure that the chart series is sorted.
- create a list report right next to the chart. Remove the list classes, and format to make it look like the legend.
- add the series to the list, sort in reverse order.
- unlock and add a 1 cell table to the list.
- create a new style string variable. The variable should be on rownumber
- for each series, add a number. 1, 2, 3, 4 etc...
- back in the list, click on the table cell, link it to the variable, and for each item in the variable, give it the corresponding color in the chart.
Or you could just say it can't be done.
Thanks so much for the response. I agree...maybe too much effort for a simple visual tweak. Cheers.
hi everybody,
Is it something new about this Problem with the newest Version ?
In Cognos 10.2 I have the same visual Problem.
thanks for your comments
Fabien