Populate Column values to X/Y axis instead of populating to legend

Populate Column values to X/Y axis instead of populating to legend

Posted by: rabin.shakya on 2 January 2018, 6:26 am EST

• 

  rabin.shakya

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 2 January 2018, 6:26 am EST

  Is it possible to populate the column values to X/Y axis, instead of populating as legend?

  Adding certain fields to rows and columns gives desirable result in the grid. However, when switching to chart, we would like to be able to switch which field goes into X/Y axis or legend without changing the fields in Rows or Columns. We are having to switch Row and Column field every time we switch from Grid to Chart view or vice versa.

  I used one of the sample project to replicate the issue we are facing. In the Grid view, the Customer is in rows and Order date is in columns and it gives us the view we want. However when switching to Graph view, the order date is shown as legend and customer is displayed in Y-axis. We want to display order date in Y-axis and customer as legend without having to change fields.

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 3 January 2018, 5:45 am EST

  Hello,

  FlexPivot’s RowFields collection contains fields that will be shown as Rows in output table, similarly ColumnFields collection contains fields that will be shown as Columns. And since grid shows data in form of Rows*Columns, this goes well.
  
  But Charts displays data in form of Axis and Series, where each Series corresponds to a Column field, X-Axis corresponds to fields of rows and Y-Axis corresponds to values. Therefore, what you are observing is by design and cannot be changed without modifying the Fields collection (at design time/run time).
  
  So, could you please share your use-case as to why you need to have Series name in Y-Axis.

  Thanks,
  
  Ruchir Agarwal