When writing statistical analysis reports, if users can join some beautifully crafted charts, an illustrated report will clarify the issue more clearly. The WPS table provides powerful charting capabilities that enable you to quickly produce a variety of commonly used data graphs. Understand and master some of the skills to adjust the chart, will achieve a multiplier effect.
How to quickly adjust chart text formatting
In the process of making a chart, the user often adjusts the size of the chart, so that the size of the text such as title, coordinate or data mark is inconsistent, which affects the beauty of the chart. As shown in Figure 1.
Figure 1 The chart originally produced
When the user adjusts the text formatting in the image above, if the individual flags are adjusted separately, the user will need to do multiple repetitions, and the following steps are followed to unify the text of the coordinates, data and logo.
Step 1 Right-click the chart area outside the chart and select chart area format from the shortcut menu that pops up.
Step 2 Select the Font tab in the Chart Area Format dialog box, as shown in Figure 2.
Figure 2 Chart Area formatting-Fonts tab
Once the adjustment is complete, the user can also adjust the other properties of the chart area, such as fill color, to make the chart more visible, and then click the OK button to take the setting into effect. The final adjustment results are shown in Figure 3:
Figure 30,000 The result of the dollar display
Many times, with the gradual improvement of the analysis report, users will add or delete some of the original data, especially after adding data to the chart, the data sequence is automatically added in order to display.
What if the user wants to adjust the sequence display order? In previous releases, the WPS table does not allow for a realignment, the user can only delete part of the sequence, and then again in order to add, the operation is more cumbersome.
In a new version of the WPS table, the WPS table adds the ability to adjust the sequence of sequences. As in the chart shown in Figure 4, the user wants to adjust the "version 751" data sequence to the "1054" data sequence (to move the 4th sequence to the 1th 2nd sequence), as follows:
Figure 4 Chart before sequence adjustment
Step 1 Right-click any sequence in the Chart column and select the chart Sequence Format menu item in the pop-up shortcut menu;
Step 2 Select the Series Order tab in the dialog box, as shown in Figure 5.
Figure 5 Chart sequence format-series order
Step 3 Click on the "Move Up" button, the "series 751" "" Up to the "series" Version 682 "", click the "OK" button to save the settings.
This allows the user to define the order in which the data sequence is displayed, and the resulting adjusted results are shown in Figure 6.
Figure 6 The chart after the sequence is readjusted
How do I make a chart data series appear evenly
In some cases, the data values of the user's chart are significantly different, and the resulting chart is not easy to see the difference in the data, as shown in Figure 7, where the data of sequence D and G are relatively large compared to other data, making other data difficult to distinguish.
Figure 7 Chart with a large difference in sequence values
At present, the WPS table provides the function of logarithmic scale, the user can adjust the scale display of the axes to adjust, the following steps are as follows:
Step 1 Mouse Double-click the "Ordinate value" on the left of the chart, and bring up the Value axis Format dialog box;
Step 2 on the Scale tab, tick the logarithmic scale check box, and adjust the display tick values, as shown in Figure 8.
Figure 8 Value axis format-use logarithmic scale
Once you use the logarithmic scale, the system will automatically press 10 of the 0 to N times the scale display, such as 1, 10, 100, and so on, after setting, the chart data differences appear more clearly.
After you have made other formatting adjustments to the chart, the final effect is shown in Figure 9.
Figure 9 Chart displayed with logarithmic scale
1. You can set the formatting of text in a chart by using the Chart Area Format dialog box.
2. Use the Data Series Format dialog box to adjust the order in which the data series is arranged.
3. Using the logarithmic scale in the coordinate value axis format enables you to display more evenly spaced values in a chart.
There are a number of options in the WPS table chart, such as chart options, plot area formatting, and grid formatting, which allow users to personalize other properties in the dialog box above to make them more beautiful.