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

[Clever_Anjos]

Put a straight table just below of your bar graph.

Mark it as "Horizontal" and use same dimension of your graph bar

[Gysbert_Wassenaar]

Well, not quite what you're asking for, but pretty close I think. See attached qvw.

[Clever_Anjos]

PFA

[#5]

thanks, Clever.

% count is ok, but alignment is lost when data changes.How can I dynamically tune the size of the table with those of the graph?

luca

[Clever_Anjos]

You mean when showing less values?

[#7]

Yes, exactly.

if the values ​​are more (or less), the alignment is lost.

many thanks

luca

[Clever_Anjos]

I don´t see how I could do that

[#9]

is it possible get the position of the legend of the x axis (1Q13, 1Q14 ..) and on this build the table?

[Clever_Anjos]

I´m almost sure not, you can´t get it