Data point at bottom side

[prma7799]

Hi swuehl‌ / All,

I am trying to show data points values bottom as like below in screen shot but not didn't get it.

PFA.

[prma7799]

Hi Kush,

Thanks for quick response but all bars display only 1 not actual values.

[Anonymous]

thats becoz through Dual() function you are assigning then only 1

Remove Dual function with 1, you will get actual values

[Anonymous]

like this?

[Anonymous]

see this for more clarity:

Dual & Exists – Useful Functions

[prma7799]

I am getting actual value but on top of the bar I want values at bottom

[tresesco · Accepted solution]

PFA

[Anonymous]

see this?

[Anonymous]

Hi,
I have on trick for your requirement please follow the below steps:
1)Create  exact similar copy of your existing chart .
2) Inside the copied chart check values on data point option and unchecked values inside the segment option.
3) Go to the axis tab and set min =0 and max =99999999
4)Make everything invisible from copied chart like caption, label, axis, border of chart , label everything.
Only make visible data point values.
5)go to the color and make the background of copied chart as fully transparent.
6)go to the layout and change the layer level to the bottom .
7)now inside the original chart make the color of each bar slightly transparent.
8)and place both chart on each other  to  get the result.

Thanks,
Sandip Satbhai

[prma7799]

Thanks tresesco‌.

What you did can you please explain lit bit.

Thanks

[tresesco]

Apart from expression, Number tab->Number format 'Expression Default' for Bottom; color/size adjustment for the Bottom exp symbols.