how to set up source data for a comparison chart

JLR

New member
Joined
Sep 29, 2014
Messages
2
Reaction score
0
Points
0
Need help with setting up source data for a comparison chart between years and types of data on a monthly basis.
Monthly Billed Rental TotalMonthly Billed JanMonthly Billed FebMonthly Billed MarMonthly Billed AprMonthly Billed MayMonthly Billed JunMonthly Billed JulMonthly Billed AugMonthly Billed SepMonthly Billed OctMonthly Billed NovMonthly 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 MonthlyNew Rental JanNew Rental FebNew Rental MarNew Rental AprNew Rental MayNew Rental JunNew Rental JulNew Rental AugNew Rental SepNew Rental OctNew Rental NovNew 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
 
Am I missing the question?
Insert Jan to Dec above your data
Multi select rows 1, 3, 4, 6, 7 (B to M)
Insert column chart
Rename the 4 series
 
Back
Top