I'm trying to get a scatter plot with years on x axis starting with a disordered series.
I'm wondering if there is a way to force my data to be ordered in a scatter plot with smooth line even if my data are not sorted by years.
Actually my starting data are sorted for other factors and i cannot sort them by years without changing everything.
if I plot my data in this way i get a line that goes back and forth while if I plot my data with data sorted by years I get a smooth upward-sloping line.
A VBA solution (without moving my data) is welcome!