No announcement yet.

scatter plot (with smooth line) with AUTOsorted x-axis values

  • Filter
  • Time
  • Show
Clear All
new posts

  • scatter plot (with smooth line) with AUTOsorted x-axis values

    Good morning,

    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.

    Years values
    1.29 200
    2.45 314
    3.12 398
    2.87 351
    5.12 502
    7.09 687
    8.33 729
    6.34 591
    9.11 828

    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!
    Last edited by VbaNoob7; November 3rd, 2018, 01:13.

  • VbaNoob7
    help!! :-)

    Leave a comment:

  • VbaNoob7
    sorry, I don't know why but I posted it twice (please admin delete the other one)

    Leave a comment: