How can I create a chart based on two non-numerical fields?

yolan
yolan โœญโœญ

Hi there!

This is probably very basic stuff, sorry for that.

I'm struggling to get some basic charts from a sheet that contains some fields related to project (Name, Project Mgr, Project Type, Health(red/amber/green)...)

This is my sheet

image.png

I'd like to have a chart showing how many red, amber or green each Project Mgs has.

Something like this, where each bar belongs to a different Project Mgr: Dave, Andy, Helen

image.png

Is this even possible?

When I create the chart I get the meessage: "The selected data cannot be reported"

Thank you!

Answers