| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
X-axis labels in charts
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 in charts
Hi,
You will find information here http://www.andypope.info/tips/tip002.htm Cheers Andy Lionel M Fridjhon wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Random Missing Axis Labels - Pivot Charts | Charts and Charting in Excel | |||
| Excel 2007 text labels in category axis - missing labels | Charts and Charting in Excel | |||
| xy-scatter-labels disappear when x-axis is changed into time-axis (XL07) | Charts and Charting in Excel | |||
| Use values instead of labels on X-axis in Area/Stacked Area Charts | Charts and Charting in Excel | |||
| axis labels on charts | Charts and Charting in Excel | |||
Linear Mode
