multiple Line Chart comparing year to year

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I would like to create a line chart that shows year to year comparison.....see attached image....how can I do this?? thanks

Photo of rocketc

rocketc

  • 694 Points 500 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 59,768 Points 50k badge 2x thumb
I suggest making a field called Year which calculates the Year.  It should be possible then to have the "series" be the Year.  I did not test that so let me know if that does or does not work.
Photo of rocketc

rocketc

  • 694 Points 500 badge 2x thumb
Mark, thanks for the advice. Question: Will I also need to create a Month field for the x axis?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 59,768 Points 50k badge 2x thumb
Actually, yes you will.  Initially make a numeric field with a formula of Month([my date field]) to test that.  It will read as numbers as opposed to words.  if you get it working and the number months bother you post back here.