| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Primary Axis Position
I hate asking such as referenial question, but I can't find this online: How
do you set the Position Axis through VB/VBA? That is, in the Format Axis dialog (right click a chart X axis and select Format Axis...) there is an option to "Position Axis" as either "On tick marks" or "Between tick marks". How can this be set programmatically? No, the macro recorder does this record this. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Primary Axis Position
Hi,
Try, ActiveChart.Axes(xlCategory).AxisBetweenCategories = False Cheers Andy George Lee wrote: I hate asking such as referenial question, but I can't find this online: How do you set the Position Axis through VB/VBA? That is, in the Format Axis dialog (right click a chart X axis and select Format Axis...) there is an option to "Position Axis" as either "On tick marks" or "Between tick marks". How can this be set programmatically? No, the macro recorder does this record this. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding second data point on primary axis of two axis chart | Charts and Charting in Excel | |||
| How to make Primary axis and Secondary X-axis have the same scale | Excel Discussion (Misc queries) | |||
| How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Excel Discussion (Misc queries) | |||
| How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Charts and Charting in Excel | |||
| Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
Hybrid Mode
