Kind of hard to describe. The main sheet lists songs in column A. Columns D-Z are dates marked 'x' if the song is played. Column C totals the 'x's from columns D-Z. I want to keep them listed in the order as they are. But, I want to create a bar graph which orders the songs from most played to least played.
One thing I tried: I made a sheet where columns A-C reference the main sheet. Sorting by totals in column C does not work - it instantly switches back to the order of the main sheet. I can make a filter which sorts by column C, and I can make a bar graph from that - it looks perfect. But the shared version ignores the filter, and every time I reload the sheet it clears the filter. So, the chart is only temporary.
How can I get the bar graph to stay sorted by C values?
Bookmarks