VBA To Re-Scale Every Excel Graph's Y-Axis Bounds Based On Chart Data Points

VBA To Re-Scale Every Excel Graph's Y-Axis Bounds Based On Chart Data Points

This VBA macro code will cycle through every graph on the ActiveWorksheet and adjust the Y-axis bounds based on the Minimum and Maximum values found within the chart's data set. The VBA code also allows you to add some padding to the bounds, so the upper bounds of the chart doesn't equal the highest data point.

Read More

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