I have been using Excel VBA to drive the creation of JMP Variability Charts through automation for a while now. Things worked great up through JMP 12.x. When JMP 13 came along, there was the well noted issue with the X-axis not displaying properly. That issue has since been resolved with JMP 13.1, as far as I understand. Anyway, my issue is a bit different than that one (which I only mentioned so that readers wouldn't assume I was raising the same question again).
My issue: The charts I am generating have the X-axis broken up by date, lot, and sub-lot. In JMP 12.x, the labels (dates, lots, etc) would rotate perpendicular to the X-axis and be displayed completely (as desired). In JMP 13.x, the labels are sometimes parallel, and sometimes perpendicular. I can't figure out any rhyme or reason why it choses one over the other. When it does chose parallel, the label does not print if there is not enough room, leaving me with unlabeled data, and confused users of my charts.
If I were making these charts interactively, I could use a few mouse clicks to rotate the X-axis labels (control over date, lot and sub-lot labels are independent). But I'm heavily invested in generating these charts through external automation, so I'm looking for a way force rotate the X-axis labels through automation.
When going from JMP 12.x to 13.x it appears that the X-axis on Variability Charts changed from being a "NomAxisBox" (or a set of them if there are multiple columns assigned to the X grouping) to being an "AxisBox" (and just one "AxisBox" even if multiple columns are assigned).
The automation documentation still discusses Variability Charts as though it is a NomAxisBox. In trying various VBA code, I was able to get the handle for the X-axis by assuming it is an AxisBox, and I think I was even able to force rotate the labels for the sub-lot grouping of the X-axis (this is the grouping closest to the axis in my case). However, I cannot figure out how to force rotate the labels for the date and lot groupings, and those are the ones that I most need rotated. I attempted getting handles of sub-graphic items (using GetSubgraphicItemByType method) but was unsuccessful (not sure if that's because it's not possible, or because I just don't know how).
Thank you in advance for any suggestions or insights.
