Sign in to join the conversation:
Is there a way to get a Smartsheet Chart in a Sight?
Chart data source, type and range
As you know a chart heavily relies on it's data source. The source of data for a chart must be a Smartsheet Sheet. In v1, the following column types will be supported for data points.
There will be support for most common data range/table (i.e. labels on the top row and labels on the left column and data in the middle). Data types must be of numeric and column types indicated above.
Column Names as LabelsOne of the unique features of SmartSheet is the ability to specify column names. If your data range does not have text as labels for the top row, the new chart widget will utilize your column names as default labels, so that you don't have to duplicated and re-enter the labels. If you wish, you can turn on/off "Using column names as labels" through the following checkbox.
Very soon! Should be within the next few weeks.
Thank you
Sasan
Charts - Switch rows/columns
When you create a chart, by default the axis on which the row and column data are plotted is set by the widget. If you wish to quickly change the way that rows and columns are plotted in the chart click on Switching rows/columns or vice versa. See example below.
(Pie charts: Depending on how your source data is structured, the Charts widget may not be able to plot the data to create a Pie chart. To potentially enable use of a Pie chart, click on Switch rows/columns.)
Clicking on for this example table
will toggle between these views
All,
Charts are now available! Please refresh your browser to get access to the Chart widget in your Dashboard. For more information and details you can also read more about Charts at this post or read through previous posts on this discussion.
Thanks
Love! Love! Love!
Awesome!
Charts against Reports
We just released the new capability to select data from your Report. You can now select a Report you have access to and then in the chart preview panel you will find a new button called "Select Columns". You can then select specific columns in your Report you want to chart against.
Chart specific columns in a range
This can also be used for a data range in a Sheet. Once you have selected a range, you can select specific columns from your data range to chart against.
You now have 10 more new chart types. Make sure to refresh your browser to get the latest chart types.
