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.

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