are there any marks for having a copy of data in the charts worksheet? would I not loose any marks if my charts worksheet contained only charts without the source data? any advice?
Hi, In your audit trail, you should only justify which data set you chose to do your charts. It is common practice to have a "charts" worksheet which include both data you used (might be fed from the workings worksheet) and the corresponding sheet such that if anything changes parameters/updated data, all will be reflected.
It's a good idea to do this for three reasons: 1. You may need to arrange the inputs to the chart in a certain way for some types of charts and you can do this here. 2. Someone checking your work can see immediately what numbers you've used. Otherwise they might need to look in several different places and jump between tabs. 3. If you make a mistake, the examiners can treat this as your "working" for the graphs and can give you marks for the parts you got right.
This is my main reason for having a 'data table' in the same sheet as my chart... avoid the "wild goose chase"!!
