Creating Chart Help

[#1]

Hi All,

I have requirement where I need to display the % of Sales from Total sales and Sales Amount in Bar chart. Currently I am able to show either % or Amount in Bar chart as Data point.

To be clear  I would like to create chart like below

I have sample data like below

Year, Sales, Category
2010, 350,Cat1
2010, 150,Cat2
2010, 175,Cat3
2011, 300,Cat1,
2011, 220,Cat2
2011, 190,Cat4
2011, 220,Cat5
2012, 250,Cat1
2012, 200,Cat2
2012, 320,Cat3

[Kushal_Chawda · Accepted solution]

Like this?

See the attached

[#3]

See attached.

[Qrishna]

The closer to your requirement we can get  is :

See attached.

[#5]

Hi Krishna,

I want the values inside the segment, not on axis. Much appreciated for reply

[#6]

[Qrishna]

You can Go with srukmana‌'s app or see attached.

Thanks

[awhitfield]

You need to have to expression, one to create the bar and % figure (bar and values on data points) and a second for the total sales (just values on data point)

HTH - Andy

[#9]

thank you all