Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
X-axis years and months
Hi,
I was migrated to excel 2007 and my graphs are broken. I created a graph in excel 2003 in which the x-axis was pointing to a A3:B33 range. The A colum contains the year (2008, 2009, etc) and the B colum contains the months (Jan-Dec). The A cells were merged to cover the months. It looks like excel 2003 was smart enough to group the months as part of the years. Does anyone know how to get my x-axis back the way it was? Thanks -- Juan Carlos Zubieta MD MPH Assistant Professor of Medicine Department of Critical Care Medicine University Of Pittsburgh School of Medicine |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
X-axis years and months
Merged cell are an anathema.
Why not unmerge, insert a new column and use a formula such as =A1&" "&B1 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Juan Carlos Zubieta" wrote in message ... Hi, I was migrated to excel 2007 and my graphs are broken. I created a graph in excel 2003 in which the x-axis was pointing to a A3:B33 range. The A colum contains the year (2008, 2009, etc) and the B colum contains the months (Jan-Dec). The A cells were merged to cover the months. It looks like excel 2003 was smart enough to group the months as part of the years. Does anyone know how to get my x-axis back the way it was? Thanks -- Juan Carlos Zubieta MD MPH Assistant Professor of Medicine Department of Critical Care Medicine University Of Pittsburgh School of Medicine |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
X-axis years and months
Hi,
It must be happening in the translation. If you plot cells laid out as you describe it works fine in 2007. However, an easier way to handle this is to NOT merge the cells an enter the year once for each group, as follows: Year Month amt 2008 Jan 58 Feb 26 Mar 24 Apr 94 May 57 Jun 83 Jul 100 Aug 37 Sep 41 Oct 21 Nov 64 Dec 73 2009 Jan 31 Feb 62 Mar 63 Apr 48 -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Juan Carlos Zubieta" wrote: Hi, I was migrated to excel 2007 and my graphs are broken. I created a graph in excel 2003 in which the x-axis was pointing to a A3:B33 range. The A colum contains the year (2008, 2009, etc) and the B colum contains the months (Jan-Dec). The A cells were merged to cover the months. It looks like excel 2003 was smart enough to group the months as part of the years. Does anyone know how to get my x-axis back the way it was? Thanks -- Juan Carlos Zubieta MD MPH Assistant Professor of Medicine Department of Critical Care Medicine University Of Pittsburgh School of Medicine |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting months between two years | Excel Discussion (Misc queries) | |||
I want to display months and years on x axis | Charts and Charting in Excel | |||
converting months to years and months??? | Excel Discussion (Misc queries) | |||
years and months | Excel Worksheet Functions | |||
function years:months | Excel Worksheet Functions |