Best way to graph counts of start year and end years?

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!
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
the post didnt post it how i wrote it--- the example data is supposed to correspond with start year, end year, count of warranties. three columns with three rows under it.
 
Upvote 0

Forum statistics

Threads
1,203,384
Messages
6,055,118
Members
444,763
Latest member
Jaapaap

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top