[Question] Graph in Google Sheets

[Dientjie]

I have a Google sheet that will have various lines (with different names of patients) and this list will increase on a monthly basis

I want each person to have their own graph, that will update automatically if new lines are added for that person

[Mike C]

Hi Dientjie - I don't know much about google sheets, but here is a link you may find helpful:

https://support.google.com/docs/answer/63824?co=GENIE.Platform%3DDesktop&hl=en

The other alternative is perhaps adding the "Google Analytics" Addon?

[New Perspective studio]

Creating a sheet hierarchy isn't that bad once you get the just of it the video above explains it well. It's mostly linking data to cells outside your current page or book that will allow you to update info on one page and then insert that info into a graph on another automatically. I don't know if this is what you mean by automated.