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


Your Answer

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

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