i have dates on my x axis, but for this graph i am not using all of it, e.g.
it goes from monday to sunday but im only using monday to wednesday and
friday to sunday, but it is showing the whole lot rather than what i have
input.
=('Rel. PE in progress'!$C$2:$CT$2,'Rel. PE in progress'!$DG$2:$DR$2)
i am using this same formula for the values on the graph and they are
showing up correctly. not sure why the difference
thanks anyone