0

I have a PivotChart that is a stacked bar chart in Excel 2016.

I want to control how the Ward numbers are displayed in the chart.

  1. I want to keep the PivotTable Ward number columns in alphabetical order.

  2. And I want to change the Ward number legend items so that they're in alphabetical order too.

I say “alphabetical order”, but I’m flexible on how “Other” is ordered. I really just want the wards to be in ascending numeric order.

enter image description here

I've looked at the Pivot Chart's properties, but I haven't found a way to set the legend order as ascending. The only way I've found to reorder the legend items is to manually move the Ward columns in the PivotTable:

enter image description here

That would work for the legend, but it would mean the PivotTable columns would be in descending order, which isn't what I want.

Question:

Is there a way to make both the PivotTable columns —and— the legend items be in alphabetical order?

For what it's worth, I have a different PivotChart, a line chart, that does what I want. I'm just not sure how to do the same thing in a bar chart. Screenshot.

User1974
  • 185

0 Answers0