![]() ![]() Finally, select the Fourth Quarter command. Click the inverted triangle button next to the Purchase date of the pivot table and select Date Filter. LEGEND (SERIES) is equivalent to the bar in the figure.Īfter creating the pivot chart, we now only want to check the sales data in the fourth quarter and don’t need the sales on other dates.ġ. Finally, drag the third field Branch to the LEGEND (SERIES) list box. AXIS (CATEGORY) is equivalent to the X-axis in the table.ģ. Then drag the second field Purchase date to the AXIS (CATEGORY) in the list box. First, we drag the Total sales field containing the value to the VALUES list box.Ģ. There are three parameters here, namely the fourth quarter, branches and total sales.ġ. Now we want to create a data pivot chart of each branch in the fourth quarter. The VALUES list box will generally be placed with fields containing numeric values, and the LEGEND (SERIES), AXIS (CATEGORY), and FILTERS will generally be placed with non- Numerical field. PivotTable Areas is divided into four list boxes, LEGEND (SERIES), AXIS (CATEGORY), VALUES, FILTERS. The field displayed in Field List is exactly the title of the first row in the table Select the PivotChart, and then we can see the PivotChart pane on the right is divided into two sections, namely Field List and PivotChart Areas. ![]() By creating a PivotChart in the PivotTable, we can display the PivotChart directly. In WPS Spreadsheet, if we use data to create a PivotChart, we will also create a PivotTable. After that, we can create an empty PivotTable and an empty PivotChart. Now select New Worksheet in the popup dialog box, and click OK. Select any cell in the data area, click the Insert tab, then the PivotChart button. ![]() Suppose we now want to create a pivot chart of the total sales of each branch in the fourth quarter. A pivot chart is a graphical representation of a pivot table, which can clearly and intuitively visualize the data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |