|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 28th, 2009, 02:41 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
Position of X axis labels
I have a graph that shows both negative and positive variances on the y axis.
Therefore the zero value axis runs thru the centre of graph and if one wants to put some labels associated with the x axis ie Jan, Feb, ... these appear in the middle of the graph not neatly below the plot area as I would prefer. Any clues? TIA -- Ken "Using Dbase dialects since 82" "Started with Visicalc in the same year" 
|
|
#2
September 28th, 2009, 02:57 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Position of X axis labels
Format the y-axis.
you should see an option to set where the x-axis crosses at. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "K_Macd" wrote: I have a graph that shows both negative and positive variances on the y axis. Therefore the zero value axis runs thru the centre of graph and if one wants to put some labels associated with the x axis ie Jan, Feb, ... these appear in the middle of the graph not neatly below the plot area as I would prefer. Any clues? TIA -- Ken "Using Dbase dialects since 82" "Started with Visicalc in the same year"
|
|
#3
September 28th, 2009, 11:25 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Position of X axis labels
Keep the axis where it is, to show where zero is. Instead, choose the
"Low" position for the tick labels. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Luke M wrote: Format the y-axis. you should see an option to set where the x-axis crosses at.
|
|
#4
September 29th, 2009, 02:10 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Position of X axis labels
Luke - That did the job!
Jon - Could't quite see that 'low' option (avail in xl2003?) but thanks for the response -- Ken "Using Dbase dialects since 82" "Started with Visicalc in the same year" "Jon Peltier" wrote: Keep the axis where it is, to show where zero is. Instead, choose the "Low" position for the tick labels. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Luke M wrote: Format the y-axis. you should see an option to set where the x-axis crosses at.
|
|
#5
September 29th, 2009, 03:22 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Position of X axis labels
In 2003 it's on the Patterns tab of the Format Axis dialog, in the
bottom right of the dialog, under Tick Mark Labels. In 2007 it's on the Axis Options tab of the Format Axis dialog, 2/3 of the way down, next to Axis Labels. The benefit of this approach is that your leave the axis at Y=0, which helps decode the plotted values. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ K_Macd wrote: Luke - That did the job! Jon - Could't quite see that 'low' option (avail in xl2003?) but thanks for the response
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
