jilllellis
New Member
- Joined
- Apr 20, 2015
- Messages
- 12
Hi. I a list of warranty start and end years. There are MANY different combos. I have combined them into a count of how many started in 2000 and ended in 2000, etc. SO i have three columns:
Start Year End Year Count of Warranties
2000 2000 x
2000 2001 x
2000 2002 x
Etc etc etc
By arranging my data this way, i went from over 70k rows to about 135. My question is, what is the best way to graph this? I have done a bubble graph and it looks a bit weird. The date range is only 15 years so that might be why my graph looks so weird. Any insight would be appreciated.
thanks!
Start Year End Year Count of Warranties
2000 2000 x
2000 2001 x
2000 2002 x
Etc etc etc
By arranging my data this way, i went from over 70k rows to about 135. My question is, what is the best way to graph this? I have done a bubble graph and it looks a bit weird. The date range is only 15 years so that might be why my graph looks so weird. Any insight would be appreciated.
thanks!