Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
I'd want to obtain this kind of graph
the chart is easy to get. The problem is the line "Change(%)".
In this section, I want the % between a quarter and the previous quarter (7,4 is 29-27=2 and 2 is 7.4% of 27). The first value is always " - ", the others are according to the results of the graph.
Again, I'd want the numbers remain aligned to the quarter (1Q13, 1Q14 ...) of the X axis of the graph.
how can I do?
Many thanks in advance.
Luca
ok, thank you very much
ciao
luca
A better solution...
I think it depends on the size of the legend.. I'll try..
thanks
luca
Hi Clever.
Your solution is what I was looking for, thank you.
luca
Just curious, but... did you even look at my solution?
Hi Gysbert.
Sure I looked at your solution (and thank you, of course!). It's a good example.
But my customer wants a graph as I posted: % (ok) and dinamic alignment (not possible, I think).
Grazie
Luca
What do you mean with dinamic alignment?
In my graph, alignment between chart and %table is lost when data changes, i.e. if the values are more (or less)..
Have you a solution for this?
luca
I think so. I've 'pimped up' my example a bit. Play around with the list boxes to see what happens.
it's an interesting solution, thanks!