InfoChart - unable to use column & line combination

[Former Member]

Please, can anyone help me create a simple InfoChart which displays one series of data as columns and another series as a line? My data source looks like this (v. simplified):

I want to show John Doe's data as columns, and Paris data as a line. This is what I get in Excel in under 5 seconds:

But I am not able to do the same in DS. Here's what I get when I try (again DS treats years as series and I am unable to swap axis):

I have tried changing my data source so that everything is in rows:

And that doesn't seem to change things at all, I still get the same InfoChart.

Please, can anyone advise how I need to structure my data source so that I get the InfoChart I want (like the one in Excel)? I have seen people doing it, and for some reason I simply can't.

Thanks,

Agata

[Former Member · Accepted solution]

Solution to this problem is described in the following threads:

https://answers.sap.com/questions/155419/waterfall-charts-in-design-studio-16.html

https://answers.sap.com/questions/138044/index.html

[Former Member]

I think I found a solution for this. I have managed to get this view at last:

As it seems Design Studio always treats your key figures (measures) as your series. In my data source the key figures where sitting in FY2017, FY2016 etc. that's why DS wouldn't put them on the x-axis. Now I have moved my key figures to John Doe and Paris office and now DS treats them as series. Plain stupid. So disconnected from how BW queries are built and forces you to structure your data sources the way DS likes them, not how you like them...