Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do i get x axis labels to display the same as they do in a worksheet?
Hi,
Im trying to chart a table as a line graph but the x axis labels do not display the same as they do in the worksheet. It only displays every other label. I can change the font size (to tiny), so then all the labels are shown, but when I paste it into Word it reverts back to the every other label. In excel 2003 you used to be able to stretch out the labels to fit etc, but i cannot find this function! Help! Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do i get x axis labels to display the same as they do in a worksheet?
In Excel 2003, double click the axis, and on the Scale tab, type a 1 in the
Categories between Tick Labels box. Even if there's a 1 there already, enter a 1 and press Enter, which will turn off the autoscaling function. I have no idea how to turn autoscaling back on. It sounds like you're asking about Excel 2007. Right click on the axis, select Format Axis, and on the Axis Options panel of the dialog, under Interval Between Labels, select Specify Interval Unit and enter 1 in the box. Turn autoscaling back on by selecting Automatic instead. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ wrote in message oups.com... Hi, Im trying to chart a table as a line graph but the x axis labels do not display the same as they do in the worksheet. It only displays every other label. I can change the font size (to tiny), so then all the labels are shown, but when I paste it into Word it reverts back to the every other label. In excel 2003 you used to be able to stretch out the labels to fit etc, but i cannot find this function! Help! Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting Y axis display labels | Charts and Charting in Excel | |||
X - axis labels | Charts and Charting in Excel | |||
Display Values under Date labels on the X-Axis... | Charts and Charting in Excel | |||
how to put x axis values in the chart instead of x axis labels | Charts and Charting in Excel | |||
Age in X-axis Labels as "YY;MM" ?? | Charts and Charting in Excel |