Help with graph of magazine subscriptions for grandkids

[JenniferMurphy]

I'd like to generate a graph showing which grandkids are getting which magazines so I can easily see when to reorder and when to move them up to the next age level. The variables are:

• Name of magazine
• Name of child
• Date of subscription
• Length of subscription (in years)

Some sample data might be:

Magazine	Child	Start Date	Length
Babybug	Billy	4/01/03	3
Babybug	Sally	8/15/06	3
Babybug	Sean	5/03/09	3
Babybug	Susan	10/08/11	3
Highlights Hello	Billy	4/01/03	3
Highlights Hello	Sally	8/15/06	3
Highlights Hello	Sean	5/03/09	3
Highlights Hello	Susan	10/08/11	3

<tbody>
</tbody>

I've uploaded a sample graph to this Dropbox folder:

https://www.dropbox.com/sh/92lg112n1z18z46/AABSdC693l7mM_CL6lHDWgbxa?dl=0

Can anyone get me pointed in the right direction for how to store the data and how to set up the graph?

 

[shg]

Maybe just calculate the exparation date and sort by that:

	A​	B​	C​	D​	E​	F​
1​	Magazine​	Child​	Renewed​	Years​	Expires​	​
2​	Babybug	Billy	04/01/2003​	3​	04/01/2006​	E2: =EDATE(C2, 12*D2)
3​	Babybug	Sally	08/15/2006​	3​	08/15/2009​
4​	Babybug	Sean	05/03/2009​	3​	05/03/2012​
5​	Babybug	Susan	10/08/2011​	3​	10/08/2014​
6​	Highlights Hello	Billy	04/01/2003​	3​	04/01/2006​
7​	Highlights Hello	Sally	08/15/2006​	3​	08/15/2009​
8​	Highlights Hello	Sean	05/03/2009​	3​	05/03/2012​
9​	Highlights Hello	Susan	10/08/2011​	3​	10/08/2014​