ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Hiding Columns with Zero Data (https://www.excelbanter.com/charts-charting-excel/77522-hiding-columns-zero-data.html)

Goodwin3338

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

Andy Pope

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