Do you want a bunch of years to the left, and a bunch of months to the
right? Put your months on the secondary axis, and include lots of
blanks in the beginning of the series data range, so the months pile up
toward the right. Include blanks at the end of the yearly series data
range to push those bars to the left. Right click the chart, choose
Chart Options, and click on the Axes tab. Check the secondary X axis,
and uncheck the secondary Y axis. Now format the two category axes,
adjust the number of blanks in both series, and adjust the gap width of
both series (double click the series, then click on the Options tab),
until they line up the way you want.
- Jon
