# Charts help - rows added to bottom of sheet **URL:** \ **Category:** Ask for Help\ **Created:** [November 8, 2019, 4:33pm UTC](https://community.glideapps.com/t/charts-help-rows-added-to-bottom-of-sheet/1799 "2019-11-08T16:33:34Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [November 8, 2019, 4:33pm UTC](https://community.glideapps.com/t/charts-help-rows-added-to-bottom-of-sheet/1799/1 "2019-11-08T16:33:34Z")
Looking for some advice on using Charts. I have everything working well for my current data, but when something is added in Glide, it gets added to the last row of the spreadsheet. From what I can tell in Google Charts, the Data Range can’t be just “C:C” to get the full column C, for example, but rather has to be a set range (which can only include “valid” cells that already exist) like C1:C1000. Even if I add 1000 rows to my sheet, my Chart can only using C1:C1000 as the Data Range. When a new item is added in Glide, it gets added to the bottom of the sheet and creates row 1001, which means my Chart is now not updating based on new data. Anyone experience this and have any advice?! Thank you ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [November 8, 2019, 5:10pm UTC](https://community.glideapps.com/t/charts-help-rows-added-to-bottom-of-sheet/1799/2 "2019-11-08T17:10:42Z")
I would duplicate the data into a new sheet. Glide will fill the first sheet and the second sheet can be hard set to 1000 rows. The date will just float within that 1000 rows and you don’t have to worry about arrayformulas getting in the way. ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [November 8, 2019, 6:04pm UTC](https://community.glideapps.com/t/charts-help-rows-added-to-bottom-of-sheet/1799/3 "2019-11-08T18:04:04Z")
This is great. Much appreciated and so simple.