Final answer:
To change the chart style on a Pivot table, John would use the Design tab, which allows for modification of chart styles and layout.
Step-by-step explanation:
When John wants to change the chart style on his Pivot table, he should use the Design tab. The Design tab in the PivotTable Chart Tools is intended for altering the appearance of pivot charts. This tab allows you to change the chart style and layout, select new color schemes, and make other modifications to how the chart is presented. The other tabs serve different purposes: 'Analyze' is used for managing the data and the pivot table itself, 'Format' is for adjusting individual elements in the chart like fonts and shapes, and 'Options' was in earlier versions of Excel and included some features now found on the Analyze tab. John would use the "Design" tab in the PivotTable chart tools to change the chart style. The "Design" tab typically provides options related to the overall appearance and layout of the chart. It includes features such as selecting different chart styles, changing colors, modifying the layout, and adding chart elements. This tab allows users to customize the visual representation of the PivotTable chart to better suit their preferences or the specific requirements of the data analysis. By accessing the "Design" tab, John can make adjustments that impact the visual presentation and overall aesthetics of the chart linked to his PivotTable.