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

RSP

Nov 3, 2021

+1 - charts are really poor in Smartsheet currently

+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

MichelleBohn

Aug 20, 2019

My team is making me look at other options for dashboards instead of smartsheets because we don't have the ability to have the goal and trend lines in the charts on our dashboard.  Does anyone have a workaround? 

They want me to use Power BI and that will be a big learning curve and so far I think that is the program that keeps crashing my laptop.  The sooner the better with updated graphs for smartsheet dashboards.

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!