Combine charts in Smartsheet

Alphonse Nwerem

I concur and would like to add a request to create combo charts. There is a major need to show a target line when presenting on a dashboard.

Thank you.

Joanne McCarthy

Yes agree this would be very helpful, is their any progress ?

Stuart MacKenzie

Agree would be helpful and have been waiting on this basic functionality for over a year. Graphs are clumsy and restricted.

Kirt Tassmer

Yes we need combined graphs. Is this being worked on?

RSP

+1 - charts are really poor in Smartsheet currently

Ines Kuo

https://community.smartsheet.com/discussion/comment/309856#Comment_309856

+1 Any update on this feature request with combined graphs in one chart? This is very basic functionality.

vnguyen08

+1, any update on this? very basic functionality

Jake Gustafson

Hello esteemed Smartsheet Community members. Please check out this Feedback & Ideas post on Combo Charts and give it an up vote to boost it for the Smartsheet backlog. I'd love to see Combo charts in 2023, let's make it happen by jumping on the topic.

Dashboards - Secondary Axis Options — Smartsheet Community

jchung

+1, would help make reports more viable for leadership teams

Paul Newcome

while combo charts in general would be great, there is a way to structure your data to display a line (or multiple lines) in conjunction with columns. If anyone is interested, please feel free to reach out.

paul.newcome@thinkspi.com

NickStaffordPM

+1, would LOVE this feature for our business reporting

Stephen_at_ODOC

https://community.smartsheet.com/discussion/comment/199726#Comment_199726

We are likely moving to PowerBI as well, as much as I like many of the features of SmartSheet. The inability to combine data into a single chart -- something Excel does with its eyes closed -- is really hindering how we can display information. Since this request seems to have been lingering for almost 5 years, now, I don't have a lot of hope that they are working on a solution.

MPath

+1

New to smartsheet, trying to design a structure for the company I work for. But even with basic thing I run into these shortcomings.

(wanted to display 5S-audit scores in a dashboard using a radarchart, it doesn't exist).

Gmacjr

Don't know if they will ever get around to updating the Chart Functionality in Smart Sheet, but if you have Microsoft 365 through your company, the work around that I found was creating the Combo Chart in a One Drive/Online based Excel file, and then embedding the chart into the Dashboard directly.

Step 1) Make sure you have your excel file in a live/online location.

Step 2) Click "Add Web Content" under the "Add Widget" Options.

Step 3) Follow the steps here on how to create an embedded string for your Excel Combo Bar Chart

Step 4) Paste the embedded string into the "Web Content" input for the "Add Web Content" Options.

Step 5) Save and confirm that everything looks the way as intended!