Block Chart

[#1]

Hi All,

I need to show both percentage ans sum in a block chart. is it possible to achieve the same.?

Thanks

[sujeetsingh]

I dont think have you checked?

[avinashelite]

Hi Reena,

Yes we can achieve this , please try like this:

=dual('Value:' & sum(Value) & chr(10) & '% = ' & sum(Value)/sum(total Value),sum(Value))

Do  *not* format at "Numbers" tab, mark it "Default" format.

[alex_nerush · Accepted solution]

Hi Reena. Yes, it is possible to achieve. You can use Dual function. See attachment.