How do I sort the data in a chart?
I have multiple charts created in a dashboard based on data in a Sheet. I don't see an option to sort each chart in ascending/descending order. It's in whatever order the data appears in the Sheet. If I sort in the Sheet, it fixes one set of charts I have, but ruins another. There should be an option in the Dashboard Chart area to sort the charts how you want. Does anyone know of an easy way to do this without completely reinventing the way the Sheet is laid out?