Charting New Territory

[dwhims]

I love projects like this for a Friday afternoon! (and of course, the big guy needs it first thing Monday morning!)

I am trying to create a graph showing (almost) daily data from 2/14/1990 through 9/30/2001, meaning I have over 3000 lines of data to chart.

I'm getting my line to chart nicely, but I'm having problems with my data labels. My ideal would be to show the beginning date, then every 12/31 date, and my ending date.

How can I tell Excel what I want and get it to respond nicely?

 

[AlohaJulio]

Try this: If the dates are in column A, insert a new column - B. In B put the formula
=IF(B16=EOMONTH(B16,0),B16,"") this will only show the last day of the month.
Make your chart with Column B as you X axis, go to chart options, on the Axes tab, choose time scale and click OK.
Double click on the X axis, go to the Scale tab and set major unit to 1 month.

That should do the trick.

EDIT: Sorry, didn't read closely the first time. The above will give you a label for the last day of each month.
Try this formula:
=IF(B16=EOMONTH(B16,12-MONTH(B16)),B16,"")