WPS Grouped Chart on macOS FAQ

When using Grouped Chart, common questions usually focus on use cases, data preparation, and secondary-axis setup; this FAQ includes 3 common questions and a 3-term glossary.

FAQ

What scenarios is a grouped chart suitable for?

1. A grouped chart is suitable when you need to show comparison values and trend values at the same time.
2. For example, you can use columns for sales and a line for year-over-year growth rate.
3. When one data series emphasizes scale and another emphasizes trend, a grouped chart can make the relationship easier to read.

Why does the chart look wrong after insertion?

1. First, check whether the selected data range includes both category labels and values.
2. Then confirm that the data series are suitable to appear in the same chart.
3. If the data series use very different scales, switch to a grouped chart subtype with a secondary axis.

What should I pay attention to when using a secondary axis?

1. First, confirm which data series uses the primary axis and which uses the secondary axis.
2. Keep the legend and series names clear to avoid misreading.
3. In reports or presentations, you can add a title or note to explain the meaning of the two axes.

Glossary