Issues with creating a Bar Graph on a Dashboard - Unable to select appropriate data


Hey everyone,

I've got a question regarding a Smartsheet Dashboard.

I have created the outline of my dashboard, and begun to pull some of the figures into it. When trying to pull the two columns I need to create a bar chart (overall employee satisfaction by department) I am unable to actually choose the two columns I need to build the chart. Both are "drop down single select" columns which should be supported by the chart widget. I keep receiving a " Selected data cannot be charted" error whenever I try to select the columns and enter the data into the widget.

Additionally, it doesn't look like I am actually able to select a full column data, but have to select individual cells within the columns - which is likely user error.

Does anyone have experience with this error and how did you work around it?