How can I combine two different sets of series in the same PowerPoint / think-cell chart?
Hi everyone,
I’m trying to understand how to structure a chart where the categories are years (e.g. 2025–2030), but I want to display two different metrics for the same set of entities.
For example, assume I have three countries: Country A, Country B, and Country C. For each year, I want to show:
- Revenue for Country A, B, and C as clustered columns
- Net Income for Country A, B, and C as lines
So the X-axis should simply be 2025, 2026, …, 2030, while the chart should somehow understand that there are two groups of series:
Revenue
- Country A
- Country B
- Country C
Net Income
- Country A
- Country B
- Country C
My issue is how to structure the underlying data so that PowerPoint / think-cell understands this distinction between the two sets of series while keeping the years as the categories.
I can manually change the colours so that they appear to be just 3 series, each for Country, but it would be rather lengthy and any change would be problematic.
Is there a specific way the datasheet needs to be structured to achieve this? Or does this require a different chart setup / multiple overlaid charts?