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
|