Change series to categories or categories to series
From Office Web Components Charts
Change series to categories or categories to series
This option is available only if your chart is based on data from a database or a PivotTable list.
- Click By Row/Column
on the toolbar.