Stacked Chart - Values and Labels

[#1]

Hi,

My query is regarding stacked charts. My requirement is to create a stacked chart where the label is not equal to the value.

Consider an example where there is a stacked chart. X-axis (dimension) is Year (2011, 2012, 2013 and 2013) and Y-axis is the stacked data for total number of flights for various airlines companies (American Airlines, Air Asia, Qataar Airways) i.e gives the count. Now, for Air Asia in particular if the # of flights is 3000 then the label on the bar should read 'Three Thousand'. Is there a way to have the labels distinct from the values in stacked charts?

Thanks in advance!

[stigchel · Accepted solution]

Yes you can use a dual function in the expression, Dual(Text,Value) and check the values on datapoints and maybe the plot values inside segments in the presentation tab.

For example (you may have to change the text representation to your needs)

Dual(Sum(Amount)/pow(10,(len(Sum(Amount))-1))&' '&pick((len(Sum(Amount))-1),'(1)','(10)','thousands')

,Sum(Amount))

See also example attached

[#3]

Thank you for the response! This solution worked perfectly for me!

[happydays1967]

Thanks! Saved a lot of time. One addition: on the 'Number' tab, set the number representation to 'Expression default' otherwise it will not show the text...

HP