Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

information about other values in a chart

Hello,

I have made a bar chart with amount on the y axis and the article name on the x-axis. Now i would like to add informations in the bar chart from another variable. This means i would like to add into the chart the values of the costs to each bar.

Thanks, Armin

1 Solution

Accepted Solutions
morgankejerhag
Partner - Creator III
Partner - Creator III

Make your chart a combination chart and add a second dimension without bars or lines. Only add the expression for the values you want tot show:

'Val 1: ' & sum(Val1) & chr(13) & 'Val 2: ' & sum(Val2)

See the attached example.

2014-11-20_07-20-12.png

Edit: Daniels post didn't show up first for some reason, but now I see that he already suggested this.

View solution in original post

8 Replies
Anonymous
Not applicable
Author

You could put them on the top of the bars like this :

Not applicable
Author

Hello Bill,

That's what i also found, but i would like to see both values.

Armin

Not applicable
Author

Could you share the sample app and requirements a bit more clarify

Not applicable
Author

attached a screenshot what i have reached2014-11-20_07-09-11.png

but i would like to have the value 4.486,30 € in the same style as the 200000 and beside the 200000 or inside the bar.

danieloberbilli
Specialist II
Specialist II

To use the example from Bill: you can show both values on top just by adding the first expression:

sum([Fact One] & ... & Sum([Fact Two])

Not applicable
Author

where should i add this formula?

can you share a screenshot or example?

danieloberbilli
Specialist II
Specialist II

Please find QVW attached

Capture19.PNG.png

morgankejerhag
Partner - Creator III
Partner - Creator III

Make your chart a combination chart and add a second dimension without bars or lines. Only add the expression for the values you want tot show:

'Val 1: ' & sum(Val1) & chr(13) & 'Val 2: ' & sum(Val2)

See the attached example.

2014-11-20_07-20-12.png

Edit: Daniels post didn't show up first for some reason, but now I see that he already suggested this.