Hiding Columns with Zero Data

[Goodwin3338]

Is is possible when creating a chart to ignore columns that have no data in
them. Such as a Data Table with 31 Days but not all days have data against
them. Ta

 

[Andy Pope]

Hi,

Maybe Jon Peltier's squeezed columns example can help.
http://peltiertech.com/Excel/Charts/SqueezeColumns.html

Cheers
Andy