Highest Rated Comments


JonPeltier58 karma

Love Pivot Tables, love Tables. Charts aren't too bad, either.

Oh yeah, and VBA is paying my mortgage.

JonPeltier47 karma

PMFJI but this is related to the data being charted. If the minimum is more than 5/6 of the maximum, then the Y axis will not start at zero. For a line or scatter chart, this is fine. For a bar or area chart it can be very misleading. I agree that it would be nice if the bar chart behavior were different, but because of the data, it's pretty obvious when you're making a chart that you need to force the axis to start at zero.

JonPeltier7 karma

Works for me, Excel 365 Insider Fast. 16.0.12527.20040. Windows 10 Enterprise.

  • Jon Peltier, Excel MVP

JonPeltier7 karma

Right next to Freeze Panes is an icon called Split. This is what you want.

  • Jon Peltier, Excel MVP

JonPeltier7 karma

Also, Excel MVP Michael ("ExcelIsFun") Girvin has written Ctrl+Shift+Enter: Mastering Excel Array Formulas