How to combine two bar graph

[kirpal singh manral]

Hi,

I have a requirement to combine two bar garphs having a common x-axis(date).

The one bar chart shouldhavebars above x-axis and the other bar chart has bars below(inverted) the x-axis having common x-axis.

Is it possible in spotfire. I am working on 7.x version.

 

Thanks

[Fabian Duerr]

Why don't you use negative values to create bars below the X-axis

 

So invert the values from one data set, combine both sets, then plot using the color by option

[kirpal singh manral]

Thanks for your response.

 

Actually i have different variables for both graphs on y-axis.

[Fabian Duerr]

Okay, I see... Then I don't know any solutions that satisfies your requirements by 100%. I suggest to put both values on the y-axis and Spotfire should automatically make two trellis for you.

[Kirsten Smith (she/her)]

Trellis on (Column names)

[Anders Gavare]

Depending on what your data looks like, it may be possible. If you can identify which rows come from dataset 'a' and which come from 'b', for example if you do Add Rows and include an origin column, then you could use an expression such as

Sum(If([origin]="a", [ValueA], -[ValueB]))on the Y axis (note the minus for ValueB), and then split on Color By that origin column. That way, origin a would be above the 0 line and origin b below. But if the values themselves are negative or add up to negative values, or if you need to do something more complicated than Sum, perhaps more thought is needed.