Make All Charts Plot Non-Visible Cells in Your Excel Workbook

Make All Charts Plot Non-Visible Cells in Your Excel Workbook

When you create a chart in Microsoft Excel, the chart's default setting is to not graph any spreadsheet cells that are hidden (or not visible).  I often like to hide or collapse (via column or row groups) data in my spreadsheets and this is a setting that is a pain to go in and manually change when you have to apply it to a bunch of charts.  Use the below macro to change every single graph in your workbook to Plot Non-Visible Cells.

Read More