kc1
03-25-2012, 03:05 PM
Hi,
I have a column chart based on a query. My query by design holds NULL values, so that I can display a list of names in the chart legend, even if there is no data against a name.
However, now of course my chart has an empty column on the left hand side.
Is there anyway of writing VBA to delete this empty column? I am no good with VBA, but thinking of an IfThenElse, i.e. If column Is Null Then delete it, Else display column?
I feel as though this must be possible, but have no idea where to start.
Thanks.
I have a column chart based on a query. My query by design holds NULL values, so that I can display a list of names in the chart legend, even if there is no data against a name.
However, now of course my chart has an empty column on the left hand side.
Is there anyway of writing VBA to delete this empty column? I am no good with VBA, but thinking of an IfThenElse, i.e. If column Is Null Then delete it, Else display column?
I feel as though this must be possible, but have no idea where to start.
Thanks.