Chart Data

AAL

Hi Smartsheet Team

I have tried to add my metrics sheet to make a chart but it keeps saying "Selected data cannot be charted." Please see below. I want to pull out the Services Events and Programming sessions to make 2 charts. Your great help on this is highly appreciated.

My data sheet is like this.

Nick Korna

Hi @AAL,

You should be able to make the charts by making a report taking the relevant columns from your sheet and then using this for the data source in your dashboard rather than trying to use the data sheet itself.

AAL

Thank you, Nick. I got that. Have a great weekend!

Nick Korna

No problem, glad it's sorted out for you now. 😊