I have a google sheet that uses the sparkline formula like '=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 the sparkline dynamically update with new entries in Excel?
Thanks in advance.
Bookmarks