Skip to main content
1 of 2
user2529589
  • 165
  • 1
  • 1
  • 5

How would you graph fiscal year data together with calendar year data?

I have 2 datasets resembling the toy example below:

  • FY . Cats
  • 2016-2017 . 1
  • 2017-2018 . 2
  • 2018-2019 . 3

Year . Dogs

  • 2016 . 3
  • 2017 . 2
  • 2018 . 1

I would like to present this both on a graph, but because 1 table's data is in fiscal year, and the other calendar year, I am unsure what the best way to visualize this trend would be.

How would you graph these two datasets together? (Excel preferred)

user2529589
  • 165
  • 1
  • 1
  • 5