14. Visuals and Their Formatting
14.6 Line and Column Combo Charts
Line and stacked column and Line and clustered column show two measures with different scales on one chart.
- Field wells: X-axis, Column y-axis, Line y-axis, Column legend, Small multiples, Tooltips.
- Example: X-axis = Order Hour; Column y-axis = Total Orders; Line y-axis = Avg Delivery Time (mins). This shows whether deliveries slow down during the 7–10 pm rush.
- Avoid when both measures use the same unit (use a normal clustered chart), or when viewers may compare column height with line height as if they shared a scale.
- Formatting: Y-axis and Secondary y-axis (titles!, range), Lines and Markers, Columns colours, data labels per series.
Ravindra Bagale's Tip
Friends, pay attention: not labelling the secondary axis is the combo-chart mistake I see most. Readers can't tell which line belongs to which scale. Always turn on both axis titles, for example "Orders" and "Avg mins", and use contrasting colours for the column and the line. Don't make this mistake!
Ravindra Bagale's Tip – मराठी
मित्रांनो, लक्ष द्या: secondary axis ला label न देणं ही combo chart मधली मला सगळ्यात जास्त दिसणारी चूक आहे. कोणती line कोणत्या scale ची आहे ते वाचकांना कळत नाही. नेहमी दोन्ही axis titles चालू करा, उदाहरणार्थ "Orders" आणि "Avg mins", आणि column आणि line साठी विरोधी रंग वापरा. ही चूक करू नका!
Ravindra Bagale's Tip – हिंदी
दोस्तों, ध्यान दो: secondary axis पर label न देना combo chart की सबसे ज़्यादा दिखने वाली गलती है. पढ़ने वाले समझ नहीं पाते कि कौन सी line किस scale की है. हमेशा दोनों axis titles चालू करो, जैसे "Orders" और "Avg mins", और column और line के लिए अलग-अलग दिखने वाले रंग इस्तेमाल करो. यह गलती मत करना!