Return to Question

improved grammar and formatting

Source Link

edit approved Jul 5, 2019 at 20:15

Mihai Chelaru

I have 2two 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

* 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 of these on a graph, but because 1the first table's data is in fiscal year, and the other is in calendar year, I am unsure what the best way to visualize this trend would be.

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

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)

I have two 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 both of these on a graph, but because the first table's data is in fiscal year, and the other is in calendar year, I am unsure what the best way to visualize this trend would be.

How would you graph these two datasets together, preferably in Excel?

Source Link

asked Jul 5, 2019 at 20:03

user2529589

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)

data-visualization excel