0

I have some code that retrieves data from a SAS Table on a server. I'm trying to chart this data using VBA, without copying it to an Worksheet first (Feeding the recordset directly into the charts)

I've had success so far with this. The problem is, my charts need to have multilevel categorical X axis, and i'm having trouble automating this only with VBA

What I'm trying to get is something like this

https://i.sstatic.net/wNgUp.jpg (I can't post the image due to lack of reputation)

But so far all my attempts lead to this

https://i.sstatic.net/66Wcj.jpg

I know I can do this if I first make a Pivot Table from my recordset and then build a chart on top of it, but as stated before I'm trying to do this without copying the data into a Sheet.

Also tried messing with TickLabel options (Multilevel and Depth), but so far to no avail.

Improve this question

1 Answer 1

Reset to default
1

I've tried everything I could think of, and I have not been able to create a multiple level categorical axis without having the axis data in a worksheet. I've tried various 1D and 2D arrays, with array elements that include various LF, CR, and CRLF characters. I've tried using the worksheet range, then converting XValues to an array, and of course, this broke the axis without providing a usable array.

Bottom line: Excel charts were designed to plot worksheet data, and you can't always get around this requirement. Most of the time I think you shouldn't waste time trying to get around it.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Thank you. It's a shame this kind of feature is not available.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.