relative position and values ​​between two graphs

[#1]

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

[#2]

ok, thank you very much

ciao

luca

[Clever_Anjos · Accepted solution]

A better solution...

[#4]

I think it depends on the size of the legend.. I'll try..

thanks

luca

[#5]

Hi Clever.

Your solution is what I was looking for, thank you.

luca

[Gysbert_Wassenaar]

Just curious, but... did you even look at my solution?

[#7]

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

[Gysbert_Wassenaar]

What do you mean with dinamic alignment?

[#9]

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

[Gysbert_Wassenaar]

I think so. I've 'pimped up' my example a bit. Play around with the list boxes to see what happens.

[#11]

it's an interesting solution, thanks!