How to set a chart in VBA to "Text axis"

[CoreyReynolds]

After searching for nearly two hours and posting this I find the answer within 10 seconds, FML.


(In case anyone is googling the same question and finds this)
.Axes(xlCategor y).CategoryType = xlCategoryScale

[CoreyReynolds]

Hello,

I am creating a chart dynamically in VBA in Access and opening it in an excel spreadsheet, which is working - except it is displaying all of the dates in between the events that I am graphing that have no information.

I have determined a fix for this (setting Axis Options: Axis Type to "Text Axis" from "Date Axis") but I'm not sure how to tell it how to do that in VBA.


Thanks for the help!