Hi,
I've been given a huge chart covering about 150 years of monthly records laid out as individual rows for each year with each month as a column. So, the sheet looks like:
YEAR 1 January, February, March, April... ...November, December
YEAR 2 January, February, March, April... ...November, December
...
...
YEAR LAST January, February, March, April... ...November, December
What I'd like to do is plot all of the data for individual months as a continuous line starting with YEAR 1 January and ending in YEAR LAST December. The chart would plot the twelve monthly points for YEAR 1 then the same line would plot the months in YEAR 2, then YEAR 3 and so on to the bottom of the sheet.
Is there a way of doing this in Excel? I haven't found an obvious way of doing it (I'm on Macintosh version 2011 if that is an extra complication).
Many thanks in advance,
Mike.
Bookmarks