How to organize data in a pivot chart? (bar chart table)

Question

I created a pivot chart from a pivot table. A chart type is a column by column. The problem with the pivot point is that it automatically generates the order of the stacks, and I can’t set them in the order I want. You know, can I change the order of the stacks in the pivot chart? I want to do this because I have a different type of chart for some data (row), and the rows should be on par with the stacks. Any ideas? Thanks!

Answer 1

The easiest way to do this is to reorder the corresponding pivot table. You should be able to drag labels to the table and see the result in the chart.

There is also another way to use the sort options in the legend drop-down menu. But I always found dragging objects around the chart to be really difficult.