Forum Discussion

Bridgewater's avatar
Bridgewater
Frequent Visitor
8 years ago
Solved

Creating a Bar Graph with Main Groups and Their Sub Groups

Hi all,   I need to calculate total sales figures for each main sales group. One main sales group has three sub groups within it. I need to show each sub groups numbers as well as the main group's ...
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi Bridgewater,

    If your problem is answered appropriately, welcome to share your solution or mark the right reply as answer. More people will benefit from here.

    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi Bridgewater,

Yes, you can create a clustered bar chart and select the sub-group as X-axis, the sales as value, please see more details in the screenshot below.



Best Regards,
Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi Bridgewater,

If your problem is answered appropriately, welcome to share your solution or mark the right reply as answer. More people will benefit from here.

Best Regards,
Angelia