nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Sign in to vote on this idea

Native Secondary Axis & Mixed Charting

adoosa · 2025-12-20T01:12:28+00:00

Problem: Current Limitations * Scale Conflicts: Currently, users cannot easily plot two data series with vastly different scales (e.g., "Budget" in millions vs. "% Complete" in decimals) on the same chart; the smaller metric becomes invisible. * Complex Workarounds: Users are forced to create "Helper Columns" (to manually…

adoosa

Problem: Current Limitations

Scale Conflicts: Currently, users cannot easily plot two data series with vastly different scales (e.g., "Budget" in millions vs. "% Complete" in decimals) on the same chart; the smaller metric becomes invisible.
Complex Workarounds: Users are forced to create "Helper Columns" (to manually normalize data) or build separate intermediary Reports just to structure the data for a dual-axis view.
Rigid Chart Types: There is no seamless way to mix chart types (e.g., Bar for the left axis, Line for the right axis) without significant manual configuration.

Proposal: One-Click Dual Axis Support

Native Axis Toggle: Add a simple configuration option in the Chart Widget to assign specific data series to a "Secondary (Right) Axis."
Mixed-Mode Visualization: Allow users to independently style the secondary axis (e.g., visualize the Primary Axis as columns and the Secondary Axis as a line) directly within the widget builder.
Direct Sheet Plotting: Eliminate the need for helper columns or reports; allow the chart to interpret disparate scales from the raw sheet data automatically.

Find more posts tagged with

Sheets

Formulas

Reports

Dashboards

Idea Submitted

Enhancement Request

Comments

kristinpereira

Adding a vote for the mixed mode piece in particular. We chart CSAT scores for 5 clients and want the overall average shown as a line across the client columns, so anyone can see at a glance who's above or below it. Our data lives in sheet summary fields, and today the only ways to get close are helper rows in the sheet or a report with workaround formulas, and even then we can't mix a line with columns or color the bars differently.

Being able to set one series as columns and another as a line, even on the same axis, would cover a huge number of target and benchmark use cases. A secondary axis would also help if we added survey response counts next to the scores, since counts and a 1 to 5 score would never fit on one scale today.