5 Replies Latest reply on Jun 11, 2018 2:42 PM by Jim Dehner

    How can you treat a date as an X value?

    Austin Haddox

      Hi I am having trouble creating trend lines for each Claimant Type. I know that my dates are considered titles of the measures. I have gotten it to work if I flip the axis in excel. However, it is not realistic time-wise to spend the time to convert it. Any help would definitely be appreciated.

       

      Here is an example of when I switched the axis and I was able to get a simplifies linear trend line. I used different data so that they weren't so close together, but the main claimant types are the same.