| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
"internal margin" and axis offsets (excel 2007)
I have been searching for hours on how to specify the distance the axis
labels are from the axis line on a chart. The only thing that I find is the "internal margin" setting under the format axis dialog box, but it is grayed out, and unselectable. Does anyone know if this is possible, and what I need to do to change it? I seem to recall that I could change this offset value in excel 97. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
"internal margin" and axis offsets (excel 2007)
Hi,
On the Format Axis dialog try Axis Options. There is a Label distance from axis property. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "jv_chile" wrote in message ... I have been searching for hours on how to specify the distance the axis labels are from the axis line on a chart. The only thing that I find is the "internal margin" setting under the format axis dialog box, but it is grayed out, and unselectable. Does anyone know if this is possible, and what I need to do to change it? I seem to recall that I could change this offset value in excel 97. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
"internal margin" and axis offsets (excel 2007)
Hi Andy, thanks for your reply... but, ummm.... no there isn't.
The fields a Axis Options Minimum Maximum Major Unit Minor Unit Values in Reverse Order Logarithmic Scale Display units Show display units label on chart Major tick mark type Minor tick mark type Axis labels (this is the closest thing, but still not quite right - only options for putting the labels above or below the chart, not to specify the offset) Vertical axis crosses Nothing about distance to the axis. Any other suggestions? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
"internal margin" and axis offsets (excel 2007)
What chart type are you using?
I tried it on a Line chart. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "jv_chile" wrote in message ... Hi Andy, thanks for your reply... but, ummm.... no there isn't. The fields a Axis Options Minimum Maximum Major Unit Minor Unit Values in Reverse Order Logarithmic Scale Display units Show display units label on chart Major tick mark type Minor tick mark type Axis labels (this is the closest thing, but still not quite right - only options for putting the labels above or below the chart, not to specify the offset) Vertical axis crosses Nothing about distance to the axis. Any other suggestions? |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
"internal margin" and axis offsets (excel 2007)
XY scatter
you are right, I just checked out line graph, and it gives the option there. So why can't I bring up the same option when using an XY scatter graph??? "Andy Pope" wrote: What chart type are you using? I tried it on a Line chart. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "jv_chile" wrote in message ... Hi Andy, thanks for your reply... but, ummm.... no there isn't. The fields a Axis Options Minimum Maximum Major Unit Minor Unit Values in Reverse Order Logarithmic Scale Display units Show display units label on chart Major tick mark type Minor tick mark type Axis labels (this is the closest thing, but still not quite right - only options for putting the labels above or below the chart, not to specify the offset) Vertical axis crosses Nothing about distance to the axis. Any other suggestions? |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
"internal margin" and axis offsets (excel 2007)
The Line axis will be category type whilst the xy-scatter is interval (true
values). Although why that should make a difference I have no idea. Why do you need to increase the offset? Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "jv_chile" wrote in message ... XY scatter you are right, I just checked out line graph, and it gives the option there. So why can't I bring up the same option when using an XY scatter graph??? "Andy Pope" wrote: What chart type are you using? I tried it on a Line chart. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "jv_chile" wrote in message ... Hi Andy, thanks for your reply... but, ummm.... no there isn't. The fields a Axis Options Minimum Maximum Major Unit Minor Unit Values in Reverse Order Logarithmic Scale Display units Show display units label on chart Major tick mark type Minor tick mark type Axis labels (this is the closest thing, but still not quite right - only options for putting the labels above or below the chart, not to specify the offset) Vertical axis crosses Nothing about distance to the axis. Any other suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you make a "split" or broken y-axis on a graph in Excel? | Charts and Charting in Excel | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Typing "true" excel 2007 change it to "TRUE" | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Hybrid Mode
