Choose and check combination charts for mixed measures in Zoho Sheet

Quick answer

A combination chart is useful when two measures describe the same categories but have different units. Orders and on-time rate can share a weekly category axis; they must not silently share one numeric scale. Start by checking the data and deciding whether two separate charts would be clearer.

Zoho’s official chart-engine announcement describes combination charts with multiple Y axes. Its current web chart help documents general chart creation and formatting, but the checked references do not establish exact current per-series type or secondary-axis controls. This guide teaches the choice, calculation and acceptance checks. It deliberately does not invent a current click-by-click combination-chart procedure or borrow controls from Zoho Analytics.

Download the practice data

Download the mixed-measures practice CSV. It contains a header and four synthetic weekly records, plain values only. It has no chart, formulas, macros, links or real customer data. A CSV does not preserve percentage formatting or an axis assignment.

Week	Orders	On-time rate	Independently calculated on-time orders
Week 1	80	90%	72
Week 2	120	85%	102
Week 3	100	95%	95
Week 4	150	80%	120

The CSV’s third column stores 0.9, 0.85, 0.95 and 0.8, not 90, 85, 95 and 80. If you import it into a private practice sheet, check that Orders and On-time rate are numeric, then apply a percentage display to the rate. For the import workflow, see CSV import and text identifiers. No import or native chart has been performed for this article.

Check the numbers before choosing a chart

With the imported header in A1:C1 and records in rows 2–5, put On-time orders in D1. Enter =B2*C2 in D2 and copy through D5. Expect 72, 102, 95 and 120. The total orders are 450 and total on-time orders are 389. A combined on-time rate is therefore =SUM(D2:D5)/SUM(B2:B5), approximately 86.44%.

Do not substitute the simple average of the four weekly rates, 87.5%, for this order-weighted result. The weeks contain different numbers of orders. These examples assume the supplied rates exactly represent each synthetic week’s counts; rounded real-world rates may not reconstruct integer counts reliably.

A combination chart can emphasize that Week 4 has the largest order count and the lowest rate. It does not prove that more orders caused a lower rate. With only four categories, do not add a causal conclusion or extrapolate a performance trend.

Make an explicit chart plan

Write the intended mapping before configuring anything:

• Category labels: Week 1 through Week 4, in that order.
• Orders: columns, measured in orders; use a zero baseline for meaningful column-height comparisons.
• On-time rate: a line with distinct markers, measured as a percentage; for this exercise, plan a clearly labeled 0%–100% scale.
• Title: Weekly orders and on-time rate. Show both series names and units, not only colors.

This is a design plan, not a claim that every deployed Zoho editor exposes those settings. Follow the general chart guide for documented chart creation. Before implementing a combination chart, verify the actual web editor’s current series-type and axis-assignment controls in its own help. If those controls cannot be established in your free account, stop that configuration step and use two ordinary charts with the same weekly categories or retain the table. Do not upgrade or use a paid trial for this exercise.

Acceptance checks for an actual chart

Once the relevant controls have been verified and configured, read every series against its own labeled axis. Check all four order values and all four percentages against the table. Confirm there are exactly four weekly categories; a total or weighted average is not a fifth week.

An order column and percentage point at the same height are not equal quantities. Their visual intersection depends on the two scales. Changing an axis maximum can change apparent alignment without changing one cell. Keep the chosen bounds explicit and do not use intersecting lines or matching heights as evidence of a relationship.

Keep the data table beside the chart or in an accessible companion location. Use series names, markers and units so color is not the only way to tell the measures apart. Check labels at the actual presentation size. No chart accessibility or exported-PDF accessibility certification is implied.

Change one record and recheck

In a separate practice copy, change Week 4’s on-time rate from 0.8 to 0.9. Its on-time count becomes 135; overall on-time orders become 404, and the weighted rate becomes approximately 89.78%. Orders must remain 450. Restore 0.8 and confirm the original 389 and 86.44% checks return.

If an actual chart does not reflect this change, inspect its source range and rate series before editing labels manually. After saving and reopening your own workbook, recheck the data, chart mapping and both axes. This is a reader acceptance test, not a claim that native saving or chart persistence was tested here.

Troubleshooting

A rate near the bottom of an orders axis may be using the wrong scale. A 9,000% display may mean 90 was entered where 0.9 was intended. A plausible 87.5% summary may be an unweighted average. A chart with correct colors can still have swapped series or category labels: check numbers and units, not appearance alone.

For relationships between two numeric variables rather than measures grouped by week, use the separate scatter-chart guide.

Sources and verification

• Zoho’s official chart-engine announcement, historical evidence for combination charts and multiple Y axes, not current UI instructions.
• Create charts in Zoho Sheet web
• Format chart elements in Zoho Sheet web

Documentation checked 23 October 2026. The original CSV, weighted calculations and changed-input/revert case were independently checked. No account, native chart, screenshot or save/reopen test was used. Exact current combination-series and secondary-axis procedures remain an explicit unverified subtask.