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
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 Only way I can figure out in to right click the y-axis, go to the scale tab and change the Category x-axis crosses at to your minimum value. This makes you data look wrong, but if this is what you want. Stopher |
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 | |||
Use values instead of labels on X-axis in Area/Stacked Area Charts | Charts and Charting in Excel | |||
X-axis labels in charts | Excel Programming | |||
axis labels on charts | Charts and Charting in Excel |