View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Possiblity of Two X Axis Graph

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.
--
HTH,
Barb Reinhardt



"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