I €˜m building a column graph using Excel 2007 and Im having difficulty
aligning a series of data with the proper dates. I have 2 series of data €“
Series 1: Includes a value for each quarter in 2009 (e.g., Mar-09, Jun-09,
etc). Series 2: Includes a value for each quarter in 2010 (e.g., Mar-10,
Jun-10, etc). After creating each series, I select the appropriate dates
(Series 1 €“ 2009 dates / Series 2 €“ 2010 dates). The first issue that Im
having is that when I select the second set of dates (for Series 2), it
overrides the first €“ so the x-axis initially shows 2009 dates, but then
changes to 2010. To get around this, I just reset the dates using the Format
Axis option €“ resulting in all the 2009 and 2010 dates appearing on the
x-axis.. Unfortunately, when I reset the dates in this manner, the 2009
columns of data are moved over to the 2010 dates €“ resulting in the Mar-09
column positioned next to the Mar-10 column. And the same applies to the
other dates as well €“ Jun 09 is positioned next to Jun-10. What I want is
the 4 quarterly columns for 2009 to be aligned with the 2009 dates and the 4
quarterly columns for 2010 to be aligned with the 2010 dates.

Any assistance you can provide would be greatly appreciated.

Mike M.