How to make a dual-coordinate chart with WPS_WPS tutorial for making a dual-coordinate chart

WBOY
Release: 2024-04-24 15:38:17
forward
527 people have browsed it

Dual coordinate chart in WPS is a powerful tool that allows you to display two data sets with different units or scales in the same chart. This tutorial will guide you through easily creating a two-coordinate chart, understanding its features and how to use it. Read on to master this powerful visualization tool to make your data analysis clearer and more effective.

The first step is to open the Excel table and enter the data.

The second step is to select the data field area and switch to the [Insert] page.

How to make a dual-coordinate chart with WPS_WPS tutorial for making a dual-coordinate chart

The third step is to click the [All Charts] control and select one of the charts. Here we select the combination chart.

How to make a dual-coordinate chart with WPS_WPS tutorial for making a dual-coordinate chart

The fourth step is to select the chart area and click the [Format Chart Area] shortcut key.

The fifth step is to expand the [Chart Options] in the pop-up properties panel and select the series with smaller values.

How to make a dual-coordinate chart with WPS_WPS tutorial for making a dual-coordinate chart

Step 6: Switch to the [Series] page, select [Secondary Axis], set the [Series Overlap] value to 0, and set the [Category Spacing] to [200%] That’s it.

The above is the detailed content of How to make a dual-coordinate chart with WPS_WPS tutorial for making a dual-coordinate chart. For more information, please follow other related articles on the PHP Chinese website!

source:zol.com.cn
Statement of this Website
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
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!