Show decades instead of every year in X Axis

[sheng]

Is there a way to show dates in X axis for decades like 1970 1980 1990 2000 instead of something like 1974 1983 1992 2001?

Thanks a lot.

[TatianaG]

Yes, you can set the AxisX.Step property to 3650 (every 10 years) as following:

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

 

chart1.AxisX.Step = 3650;