Forum Discussion

Lobojo's avatar
Lobojo
Helper I
4 years ago
Solved

Barchart with aggregation

Hi,   in Excel I was able, from a simple file with 2 levels, to create a bar chart were one of the levels were aggregated, using a Pivot table please see example below.   Is there any chance to d...
Need Help
Tutorial Requests
Lobojo's avatar
Lobojo
Helper I
4 years ago

Thanks a lot, it worked with a stacked column graph but not with another stacked column (nothing happened). You possibly know why? They are quite the same type of visual, I don't know if there is any element that prevent the usage of this feature

v-easonf-msft's avatar
v-easonf-msft
Community Support
4 years ago

Hi, Lobojo 

This has something to do with the ordering of the fields you add on your axis.

For example:

Best Regards,
Community Support Team _ Eason

  • Lobojo's avatar
    Lobojo
    Helper I
    4 years ago

    Very strange, it doesn't work either changing the order. Let me try to do few test.

     

    Anyway, thanks a lot.