Creating a graph from 3 variables

purna.desai

Hello,

I would like to create a graph in SS from using three variables: CSP name, Observations (Critical, Major and Minor) and Categories (findings). Please find below example:

I did create report from the sheet and tried to create Chart in Dashboard, but it says "Selected data can not be charted, please select a new range."

Any help would be awesome! I am open to change the way the variables are noted above, if it helps.

Thank you,

Purna

Gia Thinh

Hi purna.desai,

Add a blank Helper column in your sheet, then set Group by Helper column and Count setting as screenshots below. Hope it works for you.