8 Replies Latest reply on Aug 4, 2017 9:36 AM by Michael Gillespie

    Line Chart- Continuous line through years and months issue

    Nikolas Moutafis

      I have a line chart set up with YEAR(Ship Date) and MONTH(Ship Date) but the line doesn't continue through the whole time series because the year is separating it. I understand I can fix this by doing a Year-Month version of the Ship Date but I like the line delineating year from year and the header with the year in it. How do I get the line to continue through the years over the months?

       

      This post and this post don't quite solve the issue.

       

      -Issue

      linesdontconnect.JPG

       

      -I tried creating continuous dates as a dual axis but that doesn't work

      continuousdatesdoesntwork.JPG

       

      Thanks,

      Nik