(Design Studio 1.6) How to change the order of columns in a column infochart?

[former_member591771]

Hi all,

I have a column infochart with 2 data series, and I'm trying to change the order of the columns (e.g. if it is current - future sales now, I want future - current). I am a new user of BO Design Studio 1.6, coming from Excel (hence the "data series" term), where changing the order of the data series in a chart is a piece of cake - but I cannot find an easy solution in Design Studio. There's no relevant option in the "Additional Properties" and the only way of doing this is changing the dimension order in the query itself... but is this really the only way?

[former_member591771 · Accepted solution]

After experimenting more, it turns out that you can change the order mostly in crosstabs, not infocharts. Although sometimes it's possible for infocharts too. No clue why. But when it's not possible to edit the rows order in Design Studio (usually by editing the initial view of the datasource), then modifying the rows order in the query is the only way.