19 Replies Latest reply: Feb 5, 2014 5:58 AM by luca luca

# relative position and values between two graphs

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?

Luca

• ###### Re: relative position and values between two graphs

Put a straight table just below of your bar graph.

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

• ###### Re: Re: relative position and values between two graphs

PFA

• ###### Re: relative position and values between two graphs

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

• ###### Re: relative position and values between two graphs

You mean when showing less values?

• ###### Re: relative position and values between two graphs

Yes, exactly.

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

many thanks

luca

• ###### Re: relative position and values between two graphs

I don´t see how I could do that

• ###### Re: relative position and values between two graphs

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

• ###### Re: relative position and values between two graphs

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

• ###### Re: relative position and values between two graphs

ok, thank you very much

ciao

luca

• ###### Re: Re: Re: relative position and values between two graphs

A better solution...

• ###### Re: relative position and values between two graphs

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

thanks

luca

• ###### Re: relative position and values between two graphs

Hi Clever.

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

luca

• ###### Re: relative position and values between two graphs

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

• ###### Re: relative position and values between two graphs

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

• ###### Re: relative position and values between two graphs

What do you mean with dinamic alignment?

• ###### Re: relative position and values between two graphs

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

• ###### Re: Re: relative position and values between two graphs

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

• ###### Re: relative position and values between two graphs

it's an interesting solution, thanks!

• ###### Re: relative position and values between two graphs

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