How to Create and Customise Dual-Axis Combo Charts in Google Sheets

When presenting financial, marketing, or operational datasets, analysts frequently need to compare two metrics that operate on vastly different numerical scales or measure fundamentally different units. For example, comparing gross monthly revenue (measured in hundreds of thousands of pounds) alongside conversion rate percentages (ranging from 1% to 5%) on a standard single-axis chart results in visual failure: the conversion rate line flattens completely against the bottom baseline, rendering it illegible. Google Sheets resolves this data visualisation challenge through dual-axis combo charts. By plotting columns on a primary left vertical axis and overlaying a trendline on an independent right vertical axis, you can illustrate correlation and divergence clearly. Learning how to structure your tabular data, configure secondary axes, and customise series visual styling ensures professional presentation.

Structuring Tabular Data for Multi-Series Charting

Before launching the chart wizard in Google Sheets, your source data must be formatted cleanly in contiguous columns with unambiguous header rows. An optimal structure includes a shared dimensional axis (such as Month, Date, or Category) in the first column, followed by your primary and secondary quantitative metrics.

Month (Dimension)	Total Sales (£ – Volume)	Conversion Rate (% – Ratio)
January	£145,000	2.4%
February	£168,000	3.1%
March	£192,000	3.8%

Ensure that percentage values are formatted using the native Percentage tool (Format > Number > Percent) rather than entered as plain text strings, enabling Google Sheets to scale axis increments accurately.

Generating the Baseline Combo Chart

Once your data table is prepared, generate the initial chart object using the Insert menu.

1. Highlight the entire data range, including the header labels (e.g. A1:C13).
2. Click Insert in the top menu bar and select Chart.
3. The Chart editor sidebar opens on the right side of the screen. Under the Setup tab, click the Chart type drop-down selector.
4. Scroll down to the Line or Combo section and select Combo chart (represented by an icon featuring vertical bars overlaid with a line).
5. Verify that the X-axis field maps correctly to your dimensional column (e.g. Month) and that both metric columns populate the Series list.

Assigning the Secondary Vertical Axis to a Specific Series

By default, Google Sheets attempts to plot both series against the left vertical axis. You must manually bind the second series to a dedicated right-hand axis.

1. In the Chart editor sidebar, switch from the Setup tab to the Customise tab.
2. Click to expand the Series section.
3. In the Apply to drop-down menu, select your secondary metric series (e.g. Conversion Rate) rather than leaving it set to “Apply to all series”.
4. Locate the Type selector and choose Line (leaving your sales volume set to Columns).
5. Scroll down to find the Axis option. Change the selection from Left axis to Right axis.
6. Google Sheets instantly renders a new vertical numerical scale along the right boundary of the chart canvas, rescaling the percentage line across the entire vertical height of the grid.

Customising Axis Scale Boundaries and Number Formatting

Automated axis scaling can occasionally exaggerate minor fluctuations or cause column graphics to collide with trendline markers. Establishing custom minimum and maximum boundaries establishes visual equilibrium.

1. In the Customise tab of the Chart editor, expand the Right vertical axis section.
2. To prevent the percentage trendline from floating awkwardly at the top margin, set an explicit Min value (e.g. 0 or 0.01) and an appropriate Max value (e.g. 0.06 for 6%).
3. Under the Number format drop-down, ensure From source data or Percent is selected to display clean “%” suffixes on right-hand tick labels.
4. Next, expand the Left vertical axis section. Set the Min value to 0 to ensure sales volume columns start cleanly from the true baseline.

Formatting Data Points, Legends, and Titles for Clarity

Dual-axis charts require explicit labelling so that stakeholders immediately understand which series corresponds to which vertical scale.

1. In the Chart editor under Customise, expand Chart & axis titles.
2. Select Right vertical axis title from the drop-down menu and enter a clear label (e.g. Conversion Rate (%)).
3. Select Vertical axis title and enter a matching label for the primary scale (e.g. Monthly Revenue (£ GBP)).
4. Expand the Legend section and set the position to Top or Bottom. Use contrasting series colours (such as corporate navy blue for revenue columns and vibrant orange for the conversion line) to eliminate visual ambiguity.
5. Expand the Series section, select your line metric, and check Data points to display circular nodes on individual monthly readings.

Utilising dual-axis combo charts in Google Sheets transforms dense multidimensional spreadsheets into compelling, easily interpretable executive dashboards.