Creating a Pivot Chart¶

1. Select the top left cell of the Table, normally \(A\)2

2. Select the Data menu

3. Select the drop-down Pivot Table ribbon button and then the Pivot Chart menu entry

4. Drag and drop the required fields:

* Row / Axis fields = period_date
* Column / Legend fields = country, market, product, common_unit, common_currency
* Values = common_price
* Report Filter = price_type  

1. Right-click the period_date field in Axis Fields and change number format to mmm-yy

2. Select the Change Chart Type ribbon button and convert to a Line Chart

3. Select the Chart Layouts ribbon button to change to Layout 1 (with a Chart Title and Axis label)