8

See the below chart that was created from Google Sheets:

enter image description here

I want to reorder the positioning of the bars in the x-axis - for example, move the "Over $121" bar to the far right and move the "Between $21 to $40" bar to be second to the left. The only thing that I see that's even close to reordering is reversing the order, which is not what I want to do. Any suggestions?

2 Answers 2

2

Change the order in the spreadsheet that is the source for this chart. Afaik, neither sheets nor excel let you change the order of data directly on the chart.

4
  • 1
    The source is the list of values of data, so not sure if it will work to rearrange that
    – ooj
    Dec 16, 2018 at 2:28
  • 2
    Excel lets you change the order independently of the order in the data
    – stifin
    Apr 5, 2020 at 14:21
  • 1
    what if the data source is remote?
    – obayhan
    Apr 14, 2020 at 11:45
  • Excel lets you choose a column for X values and not choose a column for X labels. Update: uncheck the «aggregate» button in the chart settings and Sheets will behave like Excel.
    – Finesse
    May 9, 2020 at 15:14
2

Another option is to re-enter the data as a 'new series' in the order you would like it to be.

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.