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

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

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?

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

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

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

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.

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

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

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1