Hi all. I am creating a Dashboard project, based on survey results, with a variety of horizontal bar charts. However, whenever there are response options for a question that don’t have any responses, the bar charts exclude that response option. But I want all response options showing. In the example below/attached there were three response options ‘Too long’, ‘About right’ and ‘Too short’. The ‘Too short’ response option hasn’t received any responses as yet and is completely missing from the chart. But I would like it to be showing (with 0% of total responses showing).
Can anyone suggest how I might do this?
Thanks