ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   X-Axis labels (https://www.excelbanter.com/excel-programming/375024-x-axis-labels.html)

Lionel M Fridjhon

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




Nick Turner

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






All times are GMT +1. The time now is 11:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com