You have to
(1) generate the chart using script or
(2) modify a QuickBase rendered Chart to plug in the missing data. This timely post (which includes a demo) shows you the general technique of how to modify a QuickBase rendered chart:
What Chart Enhancements Do You Need?
https://quickbase-community.intuit.com/questions/1447093it isn't difficult and I was anticipating this question coming up when I made the post. In a nutshell you have to push an extra datapoint onto the x and y axes to represent the category that is missing and give it a zero count. It is a little more complicated than this because for consistency sake you should synthesize the drilldown URLs even though there is no data to drill into.
Feel free to contact me off-world if you want a solution to this problem as it involves individualized script.
