change categories to values vice versa

D

darknight_814

hello,
i'm trying to switch the axes, or categories to values and values to
categories. is there a way to switch from
Excel.XlAxisType.xlCategory to Excel.XlAxisType.xlValues
and vice versa so that i can change where the text shows up?
any help on this would be great
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crating User Form to Add Names 1
Creating an intentional 'Circular Reference' of sorts in '03 &'07 3
Combine two spreadsheets into one 3
Mail Merge Switch - Dollars to Words 0
I need ONLY subtotals copied to a second sheet 4
Delete Corresponding Cell Using ByVal 4
set Excel.Axis properties 0
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0

Top