Possiblity of Two X Axis Graph

[Fowmy]

I need to compare 2008 sales against 2009 sales side by side in asingle graph.
My data is given below

PERIOD-09 Jan 09 Feb 09 Mar 09 Apr 09
SALES-09 2500 2550 2230 3100

PERIOD-08 Jan 08 Feb 08 Mar 08 Apr 08
SALES-08 1900 1990 2301 2900

Any solution?
Fowmy

 

[Barb Reinhardt]

Add a helper column and just display month

=MONTH(SerialDate)

Use that for the X axis.

That may be the easiest way assuming you are only looking at a calendar year.

 

[Duke Carey]

Change the layout of your data to be like so:

2008 2009
Jan 16 22
Feb 25 17
Mar 11 22
Apr 26 17
May 29 21
Jun 30 25
Jul 35 14
Aug 12 12
Sep 16 29
Oct 16 17
Nov 11 12
Dec 11 20

That'll give you Jan-08 next to Jan-09, etc.