Filters in charts

edited 12/09/19 in Smartsheet Basics

I have a huge data set and that need to be filtered owner-wise in my bar/pie chart. However, I do not see any filter option available. Please help me if someone is aware of this.


  • Sasan
    Sasan Employee


    Without seeing your data structure and intended outcome it's harder for us to provide guidance or solutions.  In general, the chart widget needs a data structure that is already summarized or aggregated and in a form of a table.  Once you have the table, you can chart and then your viewers while viewing the chart can filter the view by clicking on any legend items (see example table below).  You can summarize/filter your huge data set in a Sheet (via formulas, vlookup, cell links) or via a Report.  Then you can target either the table in the sheet as your data source for the chart or target a Report and specific columns.  Hope this helps.


    Screen Shot 2018-03-19 at 12.23.21 PM.png