Home  >  Article  >  Topics  >  How to set column labels

How to set column labels

藏色散人
藏色散人Original
2020-03-31 11:05:5213128browse

How to set column labels

How to set column labels? How to set row labels and column labels

Select the data area and go to "Pivot Table" under the "Insert" option.

Recommended: "Excel Tutorial"

How to set column labels

Select the location where the "Pivot Table" is generated as "New Worksheet", and then In the "Pivot Table Field" on the right, drag the "Salesperson" field name to the "Row" field, drag the "Company Name" to the "Column" field, and drag the "Sales Quantity" to the "Value" field. Generate pivot tables that meet your needs.

How to set column labels

Select the data area, in "Chart" "Pivot Chart" under the "Insert" option, select the location where the "Pivot Table" is generated as "New Worksheet" ".

How to set column labels

Then in the "PivotTable Fields" on the right, drag the "Salesperson" field name to "Row" and drag "Company Name" to "Column" ".

How to set column labels

Drag "Sales" to the "Value" field to generate a pivot table and pivot chart that meet your needs.

How to set column labels

The above is the detailed content of How to set column labels. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn