New! Scatter charts

Brendan Reed

Hi Community,

Hot off the press, I am excited to announce a new, highly requested, chart type is now available in dashboards: Scatter charts! A fan favorite originally introduced in Smartsheet labs, we are happy to finally make this available in the main Smartsheet app.

In addition, this update will introduce a new option for the x-axis called “numeric axis”, an option to change the x-axis to display number-based data points accurately on the axis instead of evenly distributing the data points.

You will be able to create a scatter chart from the data in your sheets and reports. To get started, create a chart widget or edit an existing widget, select “Add Data”, and choose the sheet or report you’d like to use as the source for your chart.

Note: At this time “numeric axis” is only available on scatter charts.

If you'd like to learn more, check out our help content on charting in dashboards.

As always, let us know what you think through the Product Feedback form (available from the menu here in Community), and thank you to everyone who submits feedback and requests for dashboards — we appreciate everything you send us!

-Brendan

Andrée Starå

Thanks, @Brendan Reed & the Smartsheet team.

This is a fantastic addition to Charts, and I have clients that have asked for and will love this feature.

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Sarah_Ko

I love this chart! It's been super helpful for our dashboards. My only question is: is there a way not to have the scatter chart plot '0'?

Great addition! Thanks!

Samuel Mueller

@Brendan Reed I have 3 columns of data, a name, and then two data points. I can not get this to chart in a scatter chart. What am I missing? I've tried all the combinations.

troyshaun

It does seem odd that scatter sharts don't allow for multiple axis.

I was trying to move my stakeholder analyiss and chnage plan to smartsheet, realized I can't plot stakeholder analyssis matrix over. I think this leaves only excel for reporting as visuals are required.

I maybe am a bit uneducated here as well, because what is a single axis scatter chart good for?

Samuel Mueller

I feel like Smartsheet forgot about this feature

Johnny Addison

@Samuel Mueller 100% agree - I've seen a half dozen threads on here that all end the same way. It's a shame because this seems generally intuitive for every other program/app that utilizes Scatter Charts.