I have set up a number of line graphs that source historical performance scores on a battery of fitness tests from a Pivot Table – so individuals will have multiple data points over the course of time or “#N/A” if they didn’t complete that test on a particular date when they turned up.
The x-axis is set as fixed date (Jan 2015 – Jan 2019). The issue I am having is that for some individuals scores do not appear. It looks like that for the ones where it doesnt work they have a number of #N/A values (>7) preceeding the first data point..
Has anyone else encountered this?