Home >Software Tutorial >Computer Software >How to set dual coordinates in wps table wps table chart dual coordinate display settings

How to set dual coordinates in wps table wps table chart dual coordinate display settings

WBOY
WBOYOriginal
2024-08-27 10:37:40639browse

Insert some charts into the wps table to display the data in a more intuitive way. After inserting the icon into the WPS table, the system will automatically appear with chart tools, which can facilitate the editing and processing we want. If you want to set the left and right dual coordinate axes, how should you do it? In fact, the operation method is very simple. Let me share two methods below. After opening the WPS table, select the data and click All Charts in the Insert tab.

wps表格怎么设置双坐标 wps表格图表双坐标显示设置

Method 1

1. Click to switch to the combination chart column in the open window, click to select a desired combination chartstyle, and check a certain data as the secondary axis on the right side of the interface , then you can click the drop-down arrow to select the chart type you want, and then click a chart to insert it.

wps表格怎么设置双坐标 wps表格图表双坐标显示设置

2. You can see that there are coordinate axes on the left and right sides of the chart. You can also adjust the scale value in the sidebar by double-clicking it.

wps表格怎么设置双坐标 wps表格图表双坐标显示设置

Method 2 1. After inserting a data series, right-click and select Format Data Series.

wps表格怎么设置双坐标 wps表格图表双坐标显示设置

2. Click to select the secondary coordinate axis in the sidebar that opens, and you will get the dual coordinate axis.

wps表格怎么设置双坐标 wps表格图表双坐标显示设置

The above is the detailed content of How to set dual coordinates in wps table wps table chart dual coordinate display settings. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn