JonPeltier58 karma2016-11-17 17:31:55 UTC
Love Pivot Tables, love Tables. Charts aren't too bad, either.
Oh yeah, and VBA is paying my mortgage.
View HistoryShare Link
JonPeltier47 karma2016-11-17 17:04:08 UTC
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 karma2020-02-12 17:57:58 UTC
Works for me, Excel 365 Insider Fast. 16.0.12527.20040. Windows 10 Enterprise.
JonPeltier7 karma2020-02-12 17:59:49 UTC
Right next to Freeze Panes is an icon called Split. This is what you want.
JonPeltier7 karma2016-11-17 17:37:10 UTC
Also, Excel MVP Michael ("ExcelIsFun") Girvin has written Ctrl+Shift+Enter: Mastering Excel Array Formulas
Copyright © 2014 BestofAMA.com, All rights reserved.
reddit has not approved or endorsed BestofAMA, reddit design elements are trademarks of reddit inc.