Excel 2007: X-axis labeling
in [Charts]
|
Prev: Final Reminder - Microsoft Responds to the Evolution of Community
Next: Updating from 2003 to 2007: axis labels overwriting
From: Tom on 29 May 2010 21:50 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.
From: Bernard Liengme on 30 May 2010 08:58
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 "Tom" <Tom(a)discussions.microsoft.com> wrote in message news:61F3E970-1C9C-48DA-97F1-7B04D4171A3A(a)microsoft.com... > 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. |