Smartsheet Charts

Today we announced the launch of Smartsheet Labs - a place to try out new, experimental features built with the Smartsheet API.  One of these new Labs app is Smartsheet Charts, an easy way to chart or graph your Smartsheet data.  

Many of you have requested this capability so that you can do things like:

  • Illustrate sales trends
  • Provide visualizations of your project status
  • Add Smartsheet data more effectively into your presentations
  • Create dashboards with visualizations of your KPIs
Using Charts

To introduce you to the basics of using this new app, we’ll show you how to create a chart to visualize your Sales Rep's performance for the year based off data in a Sales Activity Tracking sheet (grab the template if you want to step through this with us).

Start at Smartsheet Labs and click "Login with Smartsheet."

The first time you login, you’ll need to give Smartsheet Labs access to your account.  Follow the prompts and allow Smartsheet Labs access to your Smartsheet data (you can always change this later in your Smartsheet Personal Settings).   

Once you’re logged in to Smartsheet Labs, click the link for Smartsheet Charts in the top menu.  Then click the large green plus icon to create your chart in three steps:

  • Step 1: Select the sheet you want to chart.

Use the search bar to find the sheet you’re looking for.  By default, the new chart will inherit the name of the source sheet, but you can edit it if you’d like.

  • Step 2: Choose the rows and columns from your sheet to be charted.

Remove or add columns to customize your chart.  If you remove a column by accident, add it back in by clicking “Select Columns.”

Adding and removing rows is just as easy: 

You can swap the axes of your chart here, too, just click “Switch Rows and Columns.”  When you have selected the columns and rows you need for your chart, click “Next.”

  • Step 3: Determine the right chart type for your data.

Now, choose the type of chart that best fits your data.  You can choose from Line, Column, Bar, Pie and other various types.

Not all data sets will work with every chart type – you’ll know your selected data won’t work with a certain chart type if a red error message appears.

Use the “Advanced” link to customize the colors, scale, axis labels, etc. on your chart.

Once you click “Ok” to save your chart, you’re all set! You’ll see your new chart in thumbnail format on your main Charts page.

More about Charts:
  • Calculating your data Need to do some simple calculations on your data? Use the radio button at the top of Step 2 to use one of three available aggregation functions: COUNT, AVG or SUM.
  • Chart reports  You can use Charts to visualize information from your reports, too.  Please note that currently only the first 100 rows will appear in your chart.
  • Share your Chart  You have a couple different options to share your chart with others.  If you want to email a snapshot, click the expand button on your chart, resize the window to get the size you want, and then click the download button to save it as a PNG image.  

You can also share your chart via a link, similar to sharing Google photos or Google docs.  Click the Share button to turn sharing on for your chart, then distribute the link as you see fit.  Anyone with the link will be able to see your chart.  When you turn off sharing, the link is gone for good and a brand new one will be created if you enable it again.

  • Copy your Chart  If you want to use an existing chart as your starting point, you can duplicate it with the Copy button.

Smartsheet Charts is one of two new apps in Smartsheet Labs – Smartsheet Maps is also live today. We’re just getting started and can’t wait to come up with more apps like these to help boost your productivity and extend the value of Smartsheet.  

Got an idea for the next greatest app? Let us know! We’d love to hear from you.

Categories

Comments

SS team -- keep pushing, please please keeping working on charting; I am hopeful this turns into a product. It is a super big piece of functionality. So far, I like the charts and like the dashboard. When will it be in prod?? Super important!!!

Kelly Anthony's picture
Hi Mike, Thanks for your feedback - we're working hard to get charting into the core product and are aiming for the first half of 2015. Cheers, Kelly

Kelly Anthony's picture
Hi there, The ability to add charts to a sheet or report is something that we are actively investigating now. Our product management team is currently working with other customers and is interested in learning more about the details of how you would like to use charts within Smartsheet. Please let us know if we can contact you directly to learn more! Thanks, Kelly

I just tested it and really like it. It is very easy to use and has a nice image. Any plans to release it soon?

Kelly Anthony's picture
Hi there, Thanks for your feedback – glad to hear Charts is working for you. We're hard at work to add this type of capability into the core product and are targeting the first half of 2015. Thanks again! Kelly

Please keep developing this. It is really needed. It would be FANTASTIC if I could then feed it into a dashboard type app that will use the charts and update them regularly maybe based on alerts or updates set in the smartsheet itself.

Kelly Anthony's picture
Hi John, Thanks for your feedback -- we're hard at work to add charts and an improved dashboard to the core product very soon. Stay tuned! Thanks again, Kelly

This app has so much potential, but doesn't quite cut it. The limitation on printing your charts is really quite frustrating. I would love to see the ability to group charts together so you can arrange a dashboard of charts or data tables. It goes without saying, a print function would be a winner! It is possible to also put an arranged set of charts back into a dashboard within Smartsheet itself? The product is great, it is developing just nicely, but not quite there yet.

Emily Esposito's picture
Hi Justin -- there isn't a way to put charts back into Smartsheet itself. However, the Charts in Labs today acts like a dashboard, since you can create charts from Smartsheet data and the charts will update as the data does. I've submitted your feedback for future consideration. Best, Emily

Add new comment