WPS Table Icon Landscaping Settings

Source: Internet
Author: User

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.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.