I need to create a stack bar which has Demand sales by product by month. Y-axis contains Demand sales . When mouse hovers to the stack bar it should display Margin % for each product. Let say there are 4 products type. It should show in each stack bar such as Margin% for product1 = 25%, Product2 = 35%, Product3 = 15% and Product4 = 25% ( total 100%).
There are 4 data items: Demand Sales$, Product, Margin% and Month. I can't use 100% stack bar.
Demand Sales $ shows in a Currency data format in a vertical bar(Y-axis).
Can this requirement be achieved? I need your help asap.
Thanks a lot.
I guess you are asking that how to display the values on the stack bar. If my understanding is correct Select the data item box (means in which you are drag and dropping the your data item) and in properties set as show to the values property. It will display the values on each of the stack bar.
I hope it would helps to you.
Try to use Combination Stacked Chart.Also Use Property Show Y2 Axis to yes . so that you can show one measure associated with (Percentage on Y axis) and other ie on Y 2 Axis. Use axis assignment property to associate columns you add on measures or in series to particular axis as per your requirement.