| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Axes(xlCategory).CategoryNames
I am trying to assign labels to the tickmarks on a chart in an Excel module.
I have the following code: label = "all the same" For Each tick In chtObj.Chart.Axes(xlCategory).CategoryNames tick = label Next I am getting an error because of a type mismatch. It appears that chtObj.Chart.Axes(xlCategory).CategoryNames is typed as "Variant/Double". Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adjusting the y axes on 2-axes line graphs | Charts and Charting in Excel | |||
| Run-time error '1004': Unable to set the CategoryNames property of the Axis class | Excel Programming | |||
| Run-time error '1004': Unable to set the CategoryNames property of the Axis class | Excel Programming | |||
| Run-time error '1004': Unable to set the CategoryNames property of the Axis class | Excel Programming | |||
| Axes(xlCategory).TickLabels problem | Excel Programming | |||
Threaded Mode
