'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:
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 |
|---|

