#N/A stopping graph working

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?

By: Tim

Leave a Reply

Your email address will not be published. Required fields are marked *