Start with some dummy year-based data:

Yearly
2000 0
2001 0
2002 0
2003 0
2004 0
2005 0

Make a column chart. There are no columns, because of the zero values, but
this series defines the axis. Now add your quarterly data (a sample snippet
shown below) to this chart as a new series.

Quarterly
2000 Q1 69
2000 Q2 75
2000 Q3 85
2000 Q4 97
2001 Q1 108
2001 Q2 117
2001 Q3 134

It's going to look goofed up, but let's fix it. Double click the added
series, and on the Axis tab, select Secondary.

Right click the chart and choose Chart Options (or get Chart Options from
the Chart menu). On the Axes tab, check the secondary X axis, and uncheck
the secondary Y axis. Now double click the extraneous axis as the top of the
chart, and on the Patterns tab, select None wherever possible to hide the
features of this axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"DE" wrote in message
...
I wish to know how to produce charts that use quarterly data that shows the
year only along the x-axis. And when the year is shown, have the position
of
the year label centered between annual drop lines. Is this possible?
Thank you.