PivotTables have Row fields and Column fields. What are the two corresponding fields in a PivotChart?
Understand the Problem
The question is asking for the corresponding fields in a PivotChart that relate to the Row fields and Column fields in PivotTables.
Answer
Axis (Category) fields and Legend (Series) fields.
The final answer is Axis (Category) fields and Legend (Series) fields.
Answer for screen readers
The final answer is Axis (Category) fields and Legend (Series) fields.
More Information
In a PivotChart, the corresponding fields to PivotTable Rows and Columns are the Axis (Category) fields and Legend (Series) fields. The Axis area is typically where you place time, dates, or categories, while the Legend fields are for series data.
Tips
Don't confuse the field names between PivotTables and PivotCharts; each has unique names for similar data areas.
Sources
- Pivot data in a PivotTable or PivotChart - Microsoft Support - support.microsoft.com
- How to create and customize Pivot Chart in Excel - Ablebits.com - ablebits.com
Thank you for voting!
