I have a google sheet that uses the sparkline formula '=sparkline(C6:C)' which seems to automatically add to the sparkline with new incoming data in the C column. However, this data range is not valid in Excel when trying to create a sparkline. Does anyone know how to replicate this to have it update with new entries in Excel?
Thanks in advance.
