|
Spreadsheet Dates
Dates were done of the hardest things of all. Go into Chart Options; Format Axis;
For category X - Patterns = check automatic; category Y - Check that one.
For Scale - show your starting dates.
Also on data labels, I check to show values.
If you play with this a little while, all of a sudden your dates will pop up on the botton of your spreadsheet just as you hoped they would. I use a smaller font size as I have so many dates for Paul.
It doesn't work as well when you simply click on the X axes to format it. Works best gong through chart options.
Have fun!
Kathy
|