CODEWITHSUNDEEP
arrayssortinggoogle-sheetsgraphcharts
user3760419
user3760419

Reputation: 463

Sorting data on google sheets chart

I have unsorted data in the sheet and I would like to show a chart with sorted data.

Here is an example:

enter image description here

I would like the chart to be sorted ascending, by compensation.

How can this be done with the data being structured as on the picture?

Upvotes: 27

Views: 103976

Answers (2)

bigK
bigK

Reputation: 1

Just sort the table by the column that should drive the order. After that, the graph will be adjusted.

Upvotes: -4

player0
player0

Reputation: 1

move and sort your individual tables to Sheet2 with: =SORT(Sheet1!A3:B6,2,1)

then construct your chart from there:

Upvotes: 27

Related Questions