Need help with setting up source data for a comparison chart between years and types of data on a monthly basis.
Monthly Billed Rental Total | Monthly Billed Jan | Monthly Billed Feb | Monthly Billed Mar | Monthly Billed Apr | Monthly Billed May | Monthly Billed Jun | Monthly Billed Jul | Monthly Billed Aug | Monthly Billed Sep | Monthly Billed Oct | Monthly Billed Nov | Monthly Billed Dec |
2013 | $413,000 | $371,000 | $396,000 | $488,000 | $440,000 | $402,000 | $414,000 | $457,000 | $393,000 | $490,000 | $467,000 | $395,000 |
2014 | $469,000 | $416,000 | $512,000 | $530,000 | $557,000 | $368,000 | $453,000 | $377,000 | ||||
New Rental Billed Monthly | New Rental Jan | New Rental Feb | New Rental Mar | New Rental Apr | New Rental May | New Rental Jun | New Rental Jul | New Rental Aug | New Rental Sep | New Rental Oct | New Rental Nov | New Rental Dec |
2013 | $95,000 | $129,000 | $126,000 | $148,000 | $111,000 | $107,000 | $114,000 | $107,000 | $119,000 | $126,000 | $117,000 | $85,000 |
2014 | $144,000 | $128,000 | $162,000 | $163,000 | $126,000 | $140,000 | $114,000 | $150,000 |