Configuring a Series
You can select Series in the Chart Axis column for any Data Source Columns. The data source column should have Axis dimension assigned to it.
You can display a series only on chart view, which means the pivot grid can only have a display of Chart or Pivot Grid and Chart.
Image: Month as Series in Pivot Grid Model
In this example Month is defined as a Series. All the axes columns have All (Total) enabled. The total field is available on the Specify Data Model Values page.
![Pivot grid model with series configured in pivot grid wizard.](img/i-240edad7n-c6f.png)
In the Pivot Grid Viewer you can see the model with months as series.
Image: Chart displaying series
The chart shows Month as series.
![Series displayed on a chart](img/i-240edad7n-1b7.png)
You can also drill down using the X axis. Right click and select Drilldown Intersection To. The option enables you to drill down to a datapoint in X axis, in this example you can drill down to product information for the selected month.
Image: Drilldown Intersection To
This example shows the chart with Products selected from the Drilldown Intersection To options.
![Pivot grid model showing chart with drilldown intersection fact selected](img/i-240edad7n-c70.png)
Image: Months displayed as a series on grid and chart
This example shows the grid and chart with detailed data based on the Month field.
![Series on Grid and Chart](img/i-240edad7n-18b.png)