Column to bar chart

[Jackadair]

Currently have a column in G which is a Y/N option (all answered as such)

Trying to extract this data into a a bar chart, which when the column options have been edited to either Y or N this bar chart will automatically update.

I've tried piovet tables, however is seems to have a problem with reading the data.

Any help would be great!

 

[Marius44]

HI
It would be helpful to see your file

HI,
Mario

 

[Jackadair]

Hey Mario!

Unfortunatly unable to share the file due to some security issues

 

[Marius44]

HI,
Put fantasy names and random values but compatible with your file
HI,
Mario