The basic skills of statistical analysis of data by Excel: data perspective

In the last issue, I introduced the usage of pivot table by taking the statistical process of patent information as an example.

In this issue, I will continue to explain the data perspective to you.

It directly displays key data information in the form of charts. Its visual representation is more convenient for users to view, compare and analyze data.

Statistics on the distribution of patents in each base and state.

Select the data range with the left mouse button, click the Insert menu in the menu bar, and then click PivotChart under the Chart tab to open the Create PivotChart window.

Choose where to place the PivotChart.

If you select "New Worksheet", a new worksheet will be created to place the PivotTable report;

If you select Existing Sheet, you need to select a specific location in the current form.

Drag Cardinality to the Axis (Category) field, Status to the Legend (Series) field, Number to the Value field, and change the calculation type in the Value field setting to Count.

When you create a PivotChart, a PivotTable report is automatically created.

(1) Change the chart style in the Design menu or the chart style on the right side of the chart.

(2) Adjust the chart elements on the right side of the chart: if Data Table is checked, the data table can be displayed at the bottom of the chart; Check Chart Title to add a title bar.

(3) Filter the "Axis (Category)" field/"Legend (Series)" field in the chart, and only display the chart part with specific options.