New data not automatically adding to Dashboard with cell linking of full column
I have set up a dashboard with a chart that is pulling in submission dates from a tracking sheet to report # of submissions per week. I've selected the whole column so that it will automatically populate as new data is added. New data is added either via a FORM submission or is manually entered by adding new rows. I've tried the full column selection as well as a range selection from within the column, but either way it is not picking up the new data as it is added and I'm forced to manually update the linking multiple times through-out the week. IS there something that you would recommend I do differently?
Thanks for your help!