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. You can also use the angle axis buttons on the chart toolbar to change the angle of the value and category axis.A pivot chart is a graphical representation of a pivot table, which can clearly and intuitively visualize the data.
Click the OK button to accept the axis format changes. The Alignment tabs let you define text orientation (see lesson 11). The Number tab lets you define the format of numbers displayed in the axis (see lesson 12). The Scale tab lets you define numeric intervals on the value (Y) axis scale. The Patterns tab lets you define borders and tick marks. The Format Axis dialog box contains five different tabs-Patterns, Scale, Font, Number, and Alignment-that can be used to format the axis. Click the Format button on the Chart toolbar (or double-click the chart axis). 
Click anywhere in the axis label you want to edit:. When formatting the axis labels in your chart, you can adjust the numbers on the scale of the chart, as well as change font, color, and style. The Y axis runs up and down on the graph, while the X axis runs left to right. The number of items might be plotted on the Y axis, while the month may be plotted on the X axis. The number of items sold in January is data on two dimensions: number of items and month. In Excel, a graph represents a data in two dimensions. We've previously made reference to a Y axis and an X axis in Excel. The only way to change the actual text that appears in the chart legend is to change the source data in the worksheet. Click the OK button to accept the chart legend format changes. The Placement tab lets you define the location where the legend will appear on the chart. The Font tab lets you define font, font style, size, and color. The Patterns tab lets you define borders and fill colors. The Format Legend dialog box contains three different tabs-Patterns, Font, and Alignment-that can be used to format the chart title. Click the Format button on the Chart toolbar (or double-click the chart legend). (This button acts like a toggle by turning the display on or off.) Press the show/hide legend button on the Chart toolbar to turn on the legend display. The chart legend, like the chart title and category axis labels, can be formatted to your liking. Like a roadmap, the legend identifies what different colors or objects represent in the chart. The chart legend displays useful information about the chart.
0 kommentar(er)
