I have these two charts which pull the same data from the same table. The legend items appear in reverse order in the second chart. Anyone know how to make those match?

1 Answer 1


In Google Sheets, the order of the chart legend is based on the order of Series added to the chart. To reorder the legend, edit the chart and remove all series. Add the series back in the order that you'd like to see them displayed.

Note: On some charts (notably the "stacked" varieties), you have to add the series in reverse order to get the desired result.

Stacked Column Chart with series order mapped to legend

  • 2
    Thanks for answering. If this is the case, this is the worst interface imaginable. I guess it's time for me to abandon Google Sheets and just go back to using Numbers.app again. Either way, thanks for answering my question.
    – awesame
    Jun 3, 2022 at 14:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.