Forum Discussion
A self-updating graph...
Hi, all. If I could borrow on your expert knowledge again. I am tracking the number of piles we are installing on our job. Usually only 3 or 4 a day so we have a date column that looks like ...
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.
I've sorted it...
I filtered it out in the table list!
Thanks for your help!
N
Nice one...
However, I have an issue with using this method. As the spreadsheet is partially populated, the date column extends to the bottom of it, so when I process the table & graph, I get this '(blank)' row and any dates added afterwards drop in below it:
Is there a way to get it to not process the blank sections? I've tried unclicking the filter in the table, but it still throws it out. Obviously, there is no blank line between 25/11/22 & 26/11/22 on the source...
TIA
Cheers
N