combining multiple years of monthly revenue data to create one line chart

**bobkaf** · 11-23-2021, 11:08 AM

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
2016 $94,185 $123,950 $281,780 $218,971 $177,047 $259,916 $135,881 $142,520 $214,696 $259,260 $185,919 $137,239
2017 $111,693 $127,249 $262,769 $213,567 $213,686 $203,014 $124,350 $132,525 $154,631 $213,944 $182,418 $126,189
2018 $73,203 $112,872 $219,285 $172,592 $217,152 $221,420 $113,473 $153,722 $284,720 $195,159 $162,902 $110,964

Excel easily creates a chart that would have 3 lines (years) of monthly revenue data. How do I easily make it so that the chart is one continuous month to month line instead of ending up with 3 lines?

**6StringJazzer** · 11-23-2021, 11:28 AM

Redesign your data so that the date is in the first column and the amount is in the second column, so that all three years are in the same range.

Jan 2016	$94,185
Feb 2016	$123,950
Mar 2016	$281,780
Apr 2016	$218,971
May 2016	$177,047
Jun 2016	$259,916
Jul 2016	$135,881
Aug 2016	$142,520
Sep 2016	$214,696
Oct 2016	$259,260
Nov 2016	$185,919
Dec 2016	$137,239
Jan 2017	$111,693
Feb 2017	$127,249
Mar 2017	$262,769
Apr 2017	$213,567
May 2017	$213,686
Jun 2017	$203,014
Jul 2017	$124,350
Aug 2017	$132,525
Sep 2017	$154,631
Oct 2017	$213,944
Nov 2017	$182,418
Dec 2017	$126,189
Jan 2018	$73,203
Feb 2018	$112,872
Mar 2018	$219,285
Apr 2018	$172,592
May 2018	$217,152
Jun 2018	$221,420
Jul 2018	$113,473
Aug 2018	$153,722
Sep 2018	$284,720
Oct 2018	$195,159
Nov 2018	$162,902
Dec 2018	$110,964

**bobkaf** · 11-23-2021, 12:06 PM

Yes that is what I currently do, but I have multiple spreadsheets I need to present the information in both formats - multiple year after year lines. I was hoping that there would be a simple way for excel to sequence the lines automatically rather than creating two sets of the same data to keep.

**6StringJazzer** · 11-23-2021, 12:31 PM

You can use formulas to set up the alternate format of the data so it only has to be entered once.

combining multiple years of monthly revenue data to create one line chart

LinkBack

Thread Tools

Rate This Thread

Display

combining multiple years of monthly revenue data to create one line chart

Re: combining multiple years of monthly revenue data to create one line chart

Re: combining multiple years of monthly revenue data to create one line chart

Re: combining multiple years of monthly revenue data to create one line chart

Thread Information

Users Browsing this Thread

Similar Threads

How to create a line graph for revenue and different product categories

Create Line Chart with multiple lines representing multiple sets of data over time

[SOLVED] Converting a long line of monthly data in years.

Converting a long line of monthly data in years.

Find months between start and end dates and multiple the monthly revenue

Create Multiple Straight line chart with data being unique data time marks on each line

stacked column/bar chart w/ monthly data + single line of daily data

Bookmarks

Bookmarks

Posting Permissions