How can I create a chart based on two non-numerical fields?
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
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
Is this even possible?
When I create the chart I get the meessage: "The selected data cannot be reported"