Farscape2020
New Member
- Joined
- Mar 22, 2020
- Messages
- 17
- Office Version
- 365
- Platform
- Windows
Good day,
I have been creating a spreadsheet to track my students' marks. I have created a sheet that will list their marks then display the marks in column charts and complete calculations as necessary. The goal is to use this spreadsheet as a template and create copy of the sheet for each student. The issue I am having is when I copy the template to create a new sheet for each student, the charts that were created, specificially the horizontal axes, reference the original range on the template and not the new (copied) sheet that was created. My hope was the column charts would reflect the new (copy) sheet. Would anybody have some insight in why the chart only references the original template and not the new (copied) sheet? Also, how would I solve this?
Thank you.
I have been creating a spreadsheet to track my students' marks. I have created a sheet that will list their marks then display the marks in column charts and complete calculations as necessary. The goal is to use this spreadsheet as a template and create copy of the sheet for each student. The issue I am having is when I copy the template to create a new sheet for each student, the charts that were created, specificially the horizontal axes, reference the original range on the template and not the new (copied) sheet that was created. My hope was the column charts would reflect the new (copy) sheet. Would anybody have some insight in why the chart only references the original template and not the new (copied) sheet? Also, how would I solve this?
Thank you.