Graphing survey data

Copper Contributor

Hello,


I've searched tutorials and can't seem to find a way to achieve my objective. 

 

I've conducted a survey by gathering photographs of insects that visit particular specimens in a garden. Since I've probably taken pictures of the same insect multiple times, I'd like to demonstrate the presence of each insect in a compound bar chart where each plant specimen is a point on the x-axis. 

 

I would like to program a graph that recognizes the presence of a particular name within the data-set and can associate it with the given plant specimen. (ex: IF 'Apis mellifera' is present in the list of insects between a specific range, THEN a value of '1' is created.) If this is possible, then I would like to aggregate the data of multiple spreadsheets.

 

Sample Data from September 23, 2019Sample Data from September 23, 2019

Is there a way to achieve this without creating a second table manually?

Thank you for your help,
Gustavo Meneses

0 Replies