Mixed Charts
Mixed Charts in Data Interpretation combine two or more chart types (such as bar + line, table + pie, or dual-line + bar) to present different dimensions of data together. They are used when one dataset needs multiple perspectives—for example, showing both absolute values and growth trends in the same graph.
Key Skills for Solving Mixed Chart Questions
-
Identify Each Chart Type Separately
- Break the question into parts (e.g., bar shows sales, line shows profit%).
- Understand what each axis, legend, or table entry represents.
-
Cross-Referencing Data
- Many questions require comparing between the two charts.
- Example: Calculate profit value = Sales (from bar) × Profit % (from line).
-
Handle Multiple Units
- Bars may be in lakhs, line in percentage. Convert everything to the same unit before calculations.
-
Focus on Relationships
- Mixed charts test your ability to connect datasets, not just read them.
- Look for trends: when sales rise, does profit% also rise?
Conceptual Tips and Common Mistakes
- Don’t confuse axes: One y-axis may be absolute (e.g., revenue), while the other is relative (e.g., % growth).
- Watch for scale differences: Lines may exaggerate or understate compared to bars.
- Check legend/key carefully: Mixed charts often have multiple categories with colors or patterns.
- Avoid assumption bias: Trends of one variable don’t guarantee trends in another.
Examples
Example 1 — Bar + Line Chart
Bar shows sales: 200 units; Line shows profit% = 20%.
Profit = 200 × 20% = 40 units.
Example 2 — Pie + Table
Pie shows department-wise expenditure %; Table shows total expenditure = $600,000.
If HR = 15% → HR expenditure = 15% × 600,000 = $90,000.
Example 3 — Double Bar + Line
Bars show production of Cars (500) and Bikes (700). Line shows growth rate of Cars = 10%.
Cars next year = 500 × 1.10 = 550.
Example 4 — Combo of 2 Pies
Pie 1 shows revenue split; Pie 2 shows expense split.
If revenue = $1,000,000 and expenses = $800,000; Product A = 20% of revenue and 25% of expenses.
Net profit from Product A = 200,000 – 200,000 = 0.