Excel 2007: Xaxis labeling
Excel 2007 all MS updts
I have a line chart of yaxis values and xaxis dates. The both axes get
their data from the same Excel worksheet with the yaxis 'like temperatures'.
That is, values vary (oscillate from + to  and  to + back (but not
sinusoidal, just an oscillation back and forth around the y=0 line).
The issue is that the xaxis is displayed (vertically) with ALL the dates
overwriting each other for a 2 year period of time. All my data is daily
MF. Hence, for the y=0 line ALL the daily dates are bunched up. These
dates then overlay the actual data.
1) I'd like the xaxis to be labeled on the xaxis not the y=0 axis.
2) What I'd like to do is to display the dates every week or month or
nweeks (n being 1, 2, 3, 4 etc as I might visually want). How can I do this?
3) Also, is it possible to display the x and y values (coordinates) on
points of change of direction? Like when it goes from 20 and starts warming
up or it's at 50 and starts to cool down?
TIA!!
Seems simple but I can't seem to figure this out.
