Graphics of two years..

**FFrrEEddRRiiKK** · 04-04-2009, 12:57 PM

I have three columns of data.

One with year (2007 or 2008), one with month (jan - dec) and one with a number.

How should I proceed if I would like a graphic showing the months (jan - dec) on x-axis and revenue on y-axis and two lines/series in the graphic (2007 and 2008), i.e. comapring 2007 and 2008 over a similar 12-month period?

To date I've only managed to get the graphics at best in one line with all the 24 months (jan 2007 - dec 2008) across one series/line.

Please help!

**zbor** · 04-04-2009, 04:08 PM

This is what I did... I write this numbers in table:

Please Login or Register  to view this content.

(where you can put names of months instead of numbers.... jan, feb,...)

Then I took first set of numbers B 1-12 month, C2-C13

I put line 2D column

Then right click-> select data-> new series

I add another series with B14-B25 and C14-C25

And at last, rename series as 2008 and 2007...

You will get this...

untitled.JPG

(again, only names will be displayed instead of numbers for months 1-12)