Methods for a static x-axis

Hi guys

I have been wrestling with this problem for a while on and off.  I have solved it previously with battlefield dressings which worked for as long as they needed to at the time but I'd really just like to get a solid method sorted out as it comes up often enough.

I want the x-axis to be static, irrespective of the data been read by the visualisation.

I've mocked up an example:

I have asked 50 people how many of each fruit they have (apples, oranges, pears, bananas). The answers range from 1 - 4 for each fruit.  My relationships look like this:

Here's a quick display of what each query looks like:

And here's the report tab with the visualisations for each question/data set:

So you can see the issue here.  What I want is for every chart to show the x-axis values of 1,2,3,4, irrespective of whether these values are represented in each individual query.  

The idea I have been working with recently is to have a seperate and disconnected table (query) with the x-axis values(a simple 1x4 table with the values 1,2,3,4), and using that as a standard when constructing each visualisation - but I haven't managed to make it work yet and as I was struggling with that for a number of hours I thought I might as well make a post on the forums and collect ideas for how other people would go about such an issue.  

Any and all discussion on methods for this type of issue will be well received (including anyone who thinks the data moddelling is awful - if so please do let me know how you would start again).

Thanks.