| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
x-axis labelling - how to put it above the axis?
Ive got a bar chart which is mostly negative values, i.e. underneath the
x-axis. However, the x-axis labels are also underneath the axis, so therefore sitting over the bars. I want to be able to put them above the axis (which is what Id do if I were drawing it myself) but I cant work out how to do it. One would have thought it would have been a fairly simple option, but Ive searched everywhere and cant find it! I'm using Excel 97 by the way. Many thanks. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
x-axis labelling - how to put it above the axis?
Him
Set axis labels to Low. http://www.andypope.info/tips/tip002.htm Cheers Andy Got new job wrote: Ive got a bar chart which is mostly negative values, i.e. underneath the x-axis. However, the x-axis labels are also underneath the axis, so therefore sitting over the bars. I want to be able to put them above the axis (which is what Id do if I were drawing it myself) but I cant work out how to do it. One would have thought it would have been a fairly simple option, but Ive searched everywhere and cant find it! I'm using Excel 97 by the way. Many thanks. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
x-axis labelling - how to put it above the axis?
Thanks, but where do I do that? Under format axis?
"Andy Pope" wrote: Him Set axis labels to Low. http://www.andypope.info/tips/tip002.htm Cheers Andy Got new job wrote: Ive got a bar chart which is mostly negative values, i.e. underneath the x-axis. However, the x-axis labels are also underneath the axis, so therefore sitting over the bars. I want to be able to put them above the axis (which is what Id do if I were drawing it myself) but I cant work out how to do it. One would have thought it would have been a fairly simple option, but Ive searched everywhere and cant find it! I'm using Excel 97 by the way. Many thanks. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
x-axis labelling - how to put it above the axis?
Double click the x axis to bring up the format dialog.
Cheers Andy Got new job wrote: Thanks, but where do I do that? Under format axis? "Andy Pope" wrote: Him Set axis labels to Low. http://www.andypope.info/tips/tip002.htm Cheers Andy Got new job wrote: Ive got a bar chart which is mostly negative values, i.e. underneath the x-axis. However, the x-axis labels are also underneath the axis, so therefore sitting over the bars. I want to be able to put them above the axis (which is what Id do if I were drawing it myself) but I cant work out how to do it. One would have thought it would have been a fairly simple option, but Ive searched everywhere and cant find it! I'm using Excel 97 by the way. Many thanks. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
x-axis labelling - how to put it above the axis?
Yes, but 'Set axis labels to Low' is not an option. :(
Thanks anyway. "Andy Pope" wrote: Double click the x axis to bring up the format dialog. Cheers Andy Got new job wrote: Thanks, but where do I do that? Under format axis? "Andy Pope" wrote: Him Set axis labels to Low. http://www.andypope.info/tips/tip002.htm Cheers Andy Got new job wrote: Ive got a bar chart which is mostly negative values, i.e. underneath the x-axis. However, the x-axis labels are also underneath the axis, so therefore sitting over the bars. I want to be able to put them above the axis (which is what Id do if I were drawing it myself) but I cant work out how to do it. One would have thought it would have been a fairly simple option, but Ive searched everywhere and cant find it! I'm using Excel 97 by the way. Many thanks. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
x-axis labelling - how to put it above the axis?
I do not have access to xl97 at the moment. Will check later and post back.
Got new job wrote: Yes, but 'Set axis labels to Low' is not an option. :( Thanks anyway. "Andy Pope" wrote: Double click the x axis to bring up the format dialog. Cheers Andy Got new job wrote: Thanks, but where do I do that? Under format axis? "Andy Pope" wrote: Him Set axis labels to Low. http://www.andypope.info/tips/tip002.htm Cheers Andy Got new job wrote: Ive got a bar chart which is mostly negative values, i.e. underneath the x-axis. However, the x-axis labels are also underneath the axis, so therefore sitting over the bars. I want to be able to put them above the axis (which is what Id do if I were drawing it myself) but I cant work out how to do it. One would have thought it would have been a fairly simple option, but Ive searched everywhere and cant find it! I'm using Excel 97 by the way. Many thanks. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
x-axis labelling - how to put it above the axis?
Follow the instructions, and view the picture at the link Andy provided
earlier: http://www.andypope.info/tips/tip002.htm Under Tick Mark Labels, select Low. The settings are the same in Excel 97. Got wrote: Yes, but 'Set axis labels to Low' is not an option. :( Thanks anyway. "Andy Pope" wrote: Double click the x axis to bring up the format dialog. Cheers Andy Got new job wrote: Thanks, but where do I do that? Under format axis? "Andy Pope" wrote: Him Set axis labels to Low. http://www.andypope.info/tips/tip002.htm Cheers Andy Got new job wrote: Ive got a bar chart which is mostly negative values, i.e. underneath the x-axis. However, the x-axis labels are also underneath the axis, so therefore sitting over the bars. I want to be able to put them above the axis (which is what Id do if I were drawing it myself) but I cant work out how to do it. One would have thought it would have been a fairly simple option, but Ive searched everywhere and cant find it! I'm using Excel 97 by the way. Many thanks. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
x-axis labelling - how to put it above the axis?
Thanks for confirming Debra, thought I'd missed a trick there :)
Cheers Andy Debra Dalgleish wrote: Follow the instructions, and view the picture at the link Andy provided earlier: http://www.andypope.info/tips/tip002.htm Under Tick Mark Labels, select Low. The settings are the same in Excel 97. Got wrote: Yes, but 'Set axis labels to Low' is not an option. :( Thanks anyway. "Andy Pope" wrote: Double click the x axis to bring up the format dialog. Cheers Andy Got new job wrote: Thanks, but where do I do that? Under format axis? "Andy Pope" wrote: Him Set axis labels to Low. http://www.andypope.info/tips/tip002.htm Cheers Andy Got new job wrote: Ive got a bar chart which is mostly negative values, i.e. underneath the x-axis. However, the x-axis labels are also underneath the axis, so therefore sitting over the bars. I want to be able to put them above the axis (which is what Id do if I were drawing it myself) but I cant work out how to do it. One would have thought it would have been a fairly simple option, but Ive searched everywhere and cant find it! I'm using Excel 97 by the way. Many thanks. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
x-axis labelling - how to put it above the axis?
Found it this morning. I actually want 'high', not 'low'.
Thanks for your help. "Andy Pope" wrote: Thanks for confirming Debra, thought I'd missed a trick there :) Cheers Andy Debra Dalgleish wrote: Follow the instructions, and view the picture at the link Andy provided earlier: http://www.andypope.info/tips/tip002.htm Under Tick Mark Labels, select Low. The settings are the same in Excel 97. Got wrote: Yes, but 'Set axis labels to Low' is not an option. :( Thanks anyway. "Andy Pope" wrote: Double click the x axis to bring up the format dialog. Cheers Andy Got new job wrote: Thanks, but where do I do that? Under format axis? "Andy Pope" wrote: Him Set axis labels to Low. http://www.andypope.info/tips/tip002.htm Cheers Andy Got new job wrote: Ive got a bar chart which is mostly negative values, i.e. underneath the x-axis. However, the x-axis labels are also underneath the axis, so therefore sitting over the bars. I want to be able to put them above the axis (which is what Id do if I were drawing it myself) but I cant work out how to do it. One would have thought it would have been a fairly simple option, but Ive searched everywhere and cant find it! I'm using Excel 97 by the way. Many thanks. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bar chart x axis labelling | Charts and Charting in Excel | |||
| shift Y axis | Charts and Charting in Excel | |||
| Excel 2003, graph y axis labelling problem | Charts and Charting in Excel | |||
| how to add a second x axis with same Y axis value in one plot | Charts and Charting in Excel | |||
| Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
Linear Mode
