Issue with Data point in Bar Chart

[#1]

Hello everyone,

We have a business requirement to plot a waterfall chart.

I have created a bar graph which acts like a waterfall chart showing data
points on Bars. Chart is very dynamic showing hundreds of scenarios for various
filter selections. There are negative and positive values having its high range
(for example:-45000,45000) and also small values like 1,2. When we try to plot this
in bar chart, values are not visible completely.(as shown in picture)

And we should not show values in center of bars. I have shown a particular
scenario,

How can we handle this overflow of graph?

Approaches tried:

1)Increasing the length of the graph(Since data are at both ends, we are not
able to achieve it)

It would be helpful if someone answers it.

Thank you in Advance.

[manojkulkarni]

Please can you post your application, so it will be easy to have look at it.

[#3]

Hi Manoj,

It is a client application. So, can't share it. But let me check if I can share replica of same application.

Thanks

[jonathandienst]

Qv will not show the values inside the bar if the bar size is too small. You could place the values above the bar or on the axis.

You have two options

• manually/dynamically scale the chart to make the values visible. Scale the bars with an expression that also allows for some space above and below the largest positive and negative values. (=Min(Aggr(<chart expression>, <chart dimensions>))
• place the values on the x - axis.

[#5]

Hi Jonthan,

We are not showing values inside bar. Showing above the bar. Because of dynamic scale of bar chart, We are not able to fix max size of scale and values are hiding under axis.

Can you help me out for that?

Thanks

[jonathandienst]

See more detailed reply above