When using Grouped Chart, common questions usually focus on scenarios, data preparation, and chart reading. This section includes 3 common questions and a glossary.
FAQ
What scenarios are grouped charts suitable for?
- Use a grouped chart when you need to show comparison data and trend data at the same time.
- For example, you can use columns for revenue and a line for year-over-year growth.
- If the two series use very different scales, choose a dual-axis subtype.
Why does the chart look incorrect after insertion?
- Check whether the full data range is selected, especially the category labels and value columns.
- Check whether the selected grouped chart subtype matches the current data structure.
- If needed, adjust the data order and insert the chart again.
What should I pay attention to when using a dual-axis grouped chart?
- Confirm which data series uses the primary axis and which uses the secondary axis.
- Keep legend names clear so readers can distinguish the column series from the line series.
- When the two series differ greatly in scale, a dual-axis chart can improve readability.
Glossary
| Term | Definition |
|---|---|
| Grouped chart | A chart that combines two or more chart types in one chart area. |
| Dual axis | A chart setup that uses a primary axis and a secondary axis for data with different scales. |
| Data series | A set of related data points displayed in a chart according to the same rule. |