Menu
I have unsorted data in the sheet and I would like to show a chart with sorted data.
Here is an example:
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?
941
In Power View you can organize your data in a chart with one click. You can sort chart categories by a category value (in the Axis box) or by a numeric value (in the Values box). Hover over the top edge of a chart until you see sort by in the upper-left corner, then the name of a field, and then either asc or desc.
Sort an entire sheet On your computer, open a spreadsheet in Google Sheets. At the top, right-click the letter of the column you want to sort by. Click Sort sheet A to Z or Sort sheet Z to A.
move and sort your individual tables to Sheet2 with: =SORT(Sheet1!A3:B6,2,1)
then construct your chart from there:
116
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
