title: Switch Row/Column (switch axes) in xlsio chart (syncfusion)
body: <p>I am looking for a way to switch between axes of the chart being generated with <a href="https://www.syncfusion.com/" rel="nofollow noreferrer">Syncfusion</a> XlsIO library. I was not able to find any solution due to the library being commercial and less used, and the Knowledge Base being very limited.</p>
  
  <p>Basically, I am using an excel template to create new sheets and populate some data to them accordingly. I am able to do everything, but somehow the axes don't come-up the way I want. I want a way to simply do what a <img src="https://i.stack.imgur.com/GkXmM.jpg" alt="enter image description here"> (switch Row/Column button in Excel.exe) would do to the generated chart i.e. switch axes of the chart. Or may be control the axis programatically, and switch between <code>X</code> axis and <code>Y</code> axis with code.</p>
  
  <p>Though, I have a solution that we can generate the data for the chart as <code>Transpose</code> of what I am currently generating, but it seems to be a very big deal as the application being maintained is live and it is almost impossible to change the orientation (transposed) of the data now.</p>
  
  <p>Here is my code:</p>
  
  <pre><code>IChartShapes cs = ws.Charts; // ws is the worksheet being generated
  foreach (IChart cs1 in cs)
  {
      string strCName = cs1.Name;
      IRange rngs = ws.Range[cs1.Name]; //chart name and named range are the same
      cs1.PrimaryValueAxis.Font.Size = 4;
      cs1.PrimaryCategoryAxis.Font.Size = 4;
      cs1.DisplayBlanksAs = ExcelChartPlotEmpty.NotPlotted;
      cs1.DataRange = rngs;
      IChartCategoryAxis csa = cs1.PrimaryCategoryAxis;
      csa.CategoryLabels.WrapText = true;
  }
  </code></pre>
  
  <p>Any help will be much appreciated.</p>