Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
X-Axis labels
I posted the problem below many hours ago and see that nearly everyone else
has been answered except me. If their is no solution, please let me know. Thanks Lionel I produced a chart that had the X-axis scale labels along the bottom of the Plot area. While working on the chart, some negative data was produced. Since the Y-axis scale is automatic, the zero line on the Y-axis appears in the middle of the chart. I have no problem with that, but the X=axis grilines are now labelled in the middle of the plot area, just below the zero line. How can I set the labels (in this example the Date) so that they appear below the plot area? Lionel F |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
X-Axis labels
Double click on the x axis to bring up the format axis box. On the Patterns
tab, click on Low in the tick mark labels section in the bottom right. Nick "Lionel M Fridjhon" wrote: I posted the problem below many hours ago and see that nearly everyone else has been answered except me. If their is no solution, please let me know. Thanks Lionel I produced a chart that had the X-axis scale labels along the bottom of the Plot area. While working on the chart, some negative data was produced. Since the Y-axis scale is automatic, the zero line on the Y-axis appears in the middle of the chart. I have no problem with that, but the X=axis grilines are now labelled in the middle of the plot area, just below the zero line. How can I set the labels (in this example the Date) so that they appear below the plot area? Lionel F |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Overlapping time (X) axis labels with auto axis options | Charts and Charting in Excel | |||
Excel 2007 text labels in category axis - missing labels | Charts and Charting in Excel | |||
Data labels along below x axis when y axis has negative values | Charts and Charting in Excel | |||
xy-scatter-labels disappear when x-axis is changed into time-axis (XL07) | Charts and Charting in Excel | |||
how to put x axis values in the chart instead of x axis labels | Charts and Charting in Excel |