I am working on a chart in which I need to pivot (or crosstab if you will) one of the rows to become columns. Is this possible with the WebChart? Doing so when retreiving the data is difficult as the number of columns that will be created when pivoted will be variable and SQL requires hard coded columns.
Do charts do Pivots or crosstabs?
Thanks
It looks like I kinda found what I was looking for: A property called SwapRowsAndColumns.
However, it swaps all the rows and not a selected one. Therefor, if you have monthly data for different locations (like I do) the month becomes a column in the chart just like the monthly data itself.
Anyone know of a property now to not show this Month column? It is still needed to differentiate say January data from February data and so on.
there is no pivot-by-row functionality provided, so you are correct in your findings so far.
you can exclude a column using the myChart.Data.IncludeColumn(n, false) function. when SwapRowsAndColumns = true, this will effectively exclude the row with the corresponding index.