Excel 2007: X-axis labeling

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Excel 2007 all MS updts

I have a line chart of y-axis values and x-axis dates. The both axes get
their data from the same Excel worksheet with the y-axis '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 x-axis is displayed (vertically) with ALL the dates
overwriting each other for a 2 year period of time. All my data is daily
M-F. 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 x-axis to be labeled on the x-axis not the y=0 axis.
2) What I'd like to do is to display the dates every week or month or
n-weeks (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.
 
1) I am sure the x-axis is horizontal (runs left to right, not up and down).
To have it display fewer dates, right click the x-axis, open the the Format
Axis dialog and in the Axis Option set Major Units to something like 30 days
rather than 1 day.

2) By default the y-axis crosses the x-axis at y=0. You want to change this.
Right click the y-axis, open the Format Axis dialog and (near the bottom of
the dialog) change the "Horizontal axis crosses" to "Axis Value" -50 (or
some number slightly more negative than your lowest temperature reading

3) experiment with one of
Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com
Tushar's Hover Chart Label utility:
http://tushar-mehta.com/excel/software/chart_hover_label/index.html


best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
REMINDER: These newsgroups are about to die. We will all meet again at
http://social.answers.microsoft.com/Forums/en-US/category/officeexcel
 
Back
Top