Forum Discussion

ktt777's avatar
ktt777
Icon for Helper V rankHelper V
5 years ago
Solved

SORTING, DISPLAY CLUSTERED BAR CHART

Hi,  i have below clustered bar chart. I have few questions:  1.How can i sort it based on Total of blue + red value ? Right now i can only sort either blue or red value 2. How can i show percenta...
Need Help
ktt777's avatar
ktt777
Icon for Helper V rankHelper V
5 years ago

thank you a lot. 

 

Link to example file : https://1drv.ms/x/s!ApIDnMK2eKiFgRkOMv8RFE4QmD25?e=xcTQa9

Page 1:  How  to sort by total. Example 2019, Apple should be above Orange

             How to create tooltip to show : Orange, Asia 40, 62% ( percentage of Asia in Orange type only)

PAge 2: How to create tooltip to show : China, Qty 74, 55.6 % ( percentage of China over 2019 total)

 

thanks