| Home |
| Search |
| Today's Posts |
|
#1
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want graph with 2 axis, but bars overlap when second axis added | Charts and Charting in Excel | |||
| how can i plot two different y-axis graph with same x-axis | Excel Discussion (Misc queries) | |||
| can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
| Vlookup when more than one possiblity | Excel Worksheet Functions | |||
| Vlookup when more than one possiblity | Excel Discussion (Misc queries) | |||
Linear Mode
