Static Pivot Chart

[GLT]

Hi,

I have a Pivot chart that is based on a query I run on a table.

All works well, but if there are no records for a particular customer, then
nothing gets displayed in the Pivot Chart for that Customer.

Is there any way of telling the Pivot Chart to display a graph for customer
A, B, C, D E even if they have no records returned in the query?

What I am essentially try to achieve is having a static pivot chart where
the customers will not 'drop off' the chart if no records are returned back
for that particular customer in the Pivot Chart.

Any help is always greatly appreciated...

Cheers,
GLT.