Forum Discussion
A self-updating graph...
If your column with the date is formatted as a table, you can create a graph via a pivot table that displays the new data directly with "Refresh". See my example attached.
So...Now I have a table for the date, I don't appear to be able to sort the spreadsheet based on it?
If I use the drop down tab there are the options to Sort old to new, mew to old etc., but these only do that column...
I used to be able to select the whole spreadsheet and organise it via date.
Each of our piles has a unique number between 001 & 780 and they are not being installed in numeric order.
So now, how can i get the entire spreadsheet to sort, based on the date 'oldest to newest'?
When I select the entire spreadsheet now, the 'sort & filter' tab on the ribbon is greyed out and as I said up there, the tab on the table only sorts that one column....
cheers
N