I have the following display requirement: - I have a diagram which is supposed to show YOY changes (2015 vs. 2014) in four different categories => So I have two dimensions, right? - >Category< and - >Year< So far, that is fine.
I already have another chart which shows the total of these four categories for the two years => There is only one category >Year< here => In addition to the two columns, I show a line representing the positive change - a line going down horizontally from 2014 to 2015.
=> Now I would like to show the same line (from 2014 to 2015) in the other chart, but of course for every category indiidually => there should be four individual lines.
By fixing the >category< dimension in a set_analysis, I can have four individual lines, but those are not horizontal, but rather vertical.
So there should be one line for every value in the >category< dimension and it should respect the <Year< dimension - I guess I need the TOTAL qualifier for that to disregard one of the two dimensions, but how to do it?
But on the Presentation tab I can only add straight (horizontal) lines, no?
I want one line per category, but they should all be downward sloping (diagonal) from the 2014_value to the 2015_value.
Is that possible somehow?
P.S.: Sorry, that was a typo in my earlier post - the lines should not be horizontal, but they should, within each category, link the 2014_value to the 2015_value diagonally.
not quite since I don't have my desired result chart anywhere.
I will attach a screenshot of the chart I currently have - there are two dimensions as you can see. I have used a painting tool to roughly sketch the lines I want - not one continuous line, but four, each one diagonal.
too bad. Well, as this is a one-off thing, we could still revert to drawing lines as precisely as possible right in the resulting powerpoint presentation.
At least I can add to every dimension_value a text rgd. the YOY-change.
...will try and get back to you 
