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)