'How to plot a TRUE/FALSE comparative representation with non-numerical data on the Y axis

I have a table that looks like this:

Respondent ID     Breakfast       Lunch            Dinner              
1                 TRUE            FALSE            N/A      
2                 N/A             FALSE            TRUE   
4                 N/A             TRUE             FALSE    
200               FALSE           TRUE             TRUE    

And I'd like to make a comparative representation that would be similar to this:

Comparative representation of TRUE/FALSE values of Geldanamycin, Radicicol, ADP, and AMP-PNP versus residue numbers (x-axis)

The above plot has 2 value types (i.e. TRUE/FALSE), but mine has three i.e. TRUE, FALSE, or N/A.

I'd like the FALSE value to be empty, TRUE should be shaded, while N/A should be asterisk or a different shape or colour (e.g. a red dot).

In the plot, Breakfast, Lunch and Dinner should be on the y-axis; while the Respondents ID would be on the x-axis.

How can I plot this in Excel? I've tried playing around with different chart types (scatter plot, line) without success. If it’s not possible in Excel, could you please suggest another data visualisation software? Thanks in advance!



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source