Scatter chart to visualise risk data

System

This discussion was created from comments split from: How to properly use a scatter plot graph?.

Mauro Crispim

Struggling here — can anyone help?
I’m trying to build a scatter plot to visualize risk data. My table has the following columns:

• RISK ID
• PROBABILITY (1 to 5)
• IMPACT (1 to 5)
• CRITICALITY (calculated as PROBABILITY × IMPACT)

What I’m trying to achieve:

• X-axis: PROBABILITY
• Y-axis: IMPACT
• Bubble size: CRITICALITY (ideally), or at least same-size bubbles representing each RISK ID

I’ve been banging my head on this without success. Is there a Smartsheet wizard out there who’s figured this out — or a workaround to achieve something similar?

Thanks in advance!

Naeem Ejaz

• No chart type supports X-Y plotting from two different columns.

• No support for variable marker (bubble) size.

• All charts in Smartsheet are category-based (bar, line, pie, etc.), not data point-based.