Excel - how do I list specific years across the bottom of a chart?

[Seth Hill]

I'm charting a few investments. I want a simple line that goes up and down
for the value, and that's easy to do. But how do I get the chart to display
specific years (not days and months) across the bottom of the chart?

 

[Jon Peltier]

Seth -

Do you have a time-scale axis? Go to Chart Options on the Chart menu,
click on the Axes tab, and see what's checked for Category Axis. Check
Time Scale and continue.

Double click on the axis. On the Scale tab, Major Unit should be in years.

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