View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Duke Carey Duke Carey is offline
external usenet poster
 
Posts: 1,081
Default Possiblity of Two X Axis Graph

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.


"Fowmy" wrote:

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