How to Switch a Chart's Series and Category Using VBA RRS feed

  • Question

  • Excel 2013.  VBA.

    I have a chart named "DataChart"  I set its data range programmatically.  When I do that, the chart flips the series and category.  I know how to manually switch these back by clicking the "Switch Row/Column" button under the "Select data Source" dialogue.  However, I want to do this programmatically as well.  Anyone know how to accomplish that?  I tried recording a macro while doing it manually, but the macro stored no helpful code.  Thanks for any help!

    Doug Pruiett

    Friday, November 11, 2016 9:30 PM

All replies