Hiding Columns with Zero Data
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 |
Hiding Columns with Zero Data
Hi,
Maybe Jon Peltier's squeezed columns example can help. http://peltiertech.com/Excel/Charts/SqueezeColumns.html Cheers Andy Goodwin3338 wrote: 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, Microsoft MVP - Excel http://www.andypope.info |
All times are GMT +1. The time now is 10:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com