Hi,
I am working on creating Bar Charts using Pivot Tables of about a 100 questions with answers 1, 2, 3, 4, or 5. With some of these questions none of the repondents answered a 1 or a 5. When I create Pivot Tables for each questions (i.e. per question showing a barchart of number of respondents answering 1, 2, 3, 4 and 5) the x-axis does not show this 1 or 5 at all. How can I (manually) add a blank row/field for 1 or 5 in the Pivot Table or merely an empty bar on the chart?

Regards,