|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 14th, 2008, 11:02 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
Possiblity of Two X Axis Graph
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 
|
|
#2
August 15th, 2008, 02:11 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#3
August 15th, 2008, 07:06 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
