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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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/
_______
 
Back
Top