Skip to main content
Question

multiple Line Chart comparing year to year

  • October 13, 2016
  • 0 replies
  • 63 views
Forum|alt.badge.img+8
I would like to create a line chart that shows year to year comparison.....see attached image....how can I do this?? thanks

This topic has been closed for replies.

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.
Forum|alt.badge.img+8
  • BradElmore
  • Author
  • Registered
  • October 13, 2016
Mark, thanks for the advice. Question: Will I also need to create a Month field for the x axis?
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.
Forum|alt.badge.img+11
  • IvanWeiss
  • Registered
  • July 10, 2019
I know this is an old thread but how did you get the report to consistently start in January several years back?  I am trying to do something like this and have a snapshot table.  I only want the last 2 years of history plus my current year.  But I always want it to start in January.  So, for example, today is July 10th 2019.  I want my graph to start January 2017 through today.
Ivan, can you explain where in my responses above you are getting stuck?
Terms & ConditionsAccessibility statement