How to Change Axis Labels in Excel: PivotTable and Chart Guide

To create a PivotTable Chart with customized axis labels in Excel, follow these steps:

1. Prepare your data: Organize your data in a tabular format with appropriate headers.

<table>
  <thead>
    <tr>
      <th>Product</th>
      <th>Year</th>
      <th>Sales</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td>Product A</td>
      <td>2018</td>
      <td>1000</td>
    </tr>
    <!-- Add more rows as needed -->
  </tbody>
</table>

2. Create a PivotTable:

   a. Select any cell within the table. b. Go to the Insert tab and click on PivotTable. c. Choose where you want to place the PivotTable and click OK.

3. Set up the PivotTable:

   a. In the PivotTable Field List, drag the Year field to the Rows area, and the Sales field to the Values area. b. By default, Excel will sum the sales data. To change this, click on the drop-down arrow next to the Sales field in the Values area, and select the desired function (e.g., Count, Average, Max, Min).

4. Customize axis labels for the chart:

   a. Click on any cell within the PivotTable. b. Go to the Design tab and click on PivotChart. c. Choose the chart type you prefer (e.g., Column, Line, Pie, etc.). d. Once the chart is created, right-click on the chart axis you want to customize (e.g., vertical axis). e. Click on Format Axis and then Axis Options. f. In the Axis Options pane, enter the custom labels for the axis (e.g., 2018, 2019, 2020).

Now you have a PivotTable Chart with customized axis labels in Excel.

References:

• Books:

  • Excel 2013 Bible by John Walkenbach
  • Excel 2016 Power Pivot, Power Query, and Power BI: The Complete Guide to Data Analysis and Business Intelligence by Rob Collie

• Articles:

  • Microsoft Support: Create a PivotTable report
  • Microsoft Support: Customize axis labels in a PivotChart

• Online Resources:

  • Microsoft Learn: PivotTables in Excel
  • Excel Easy: PivotTables and PivotCharts