Chart Tab


Active Chart

ActiveChart.DisplayBlanksAs = xlNotPlotted | xlInterpolated | xlZero 
ActiveChart.PlotVisibleOnly = True
ActiveChart.SizeWithWindow = True

Note: The SizeWithWindow is only appropriate for charts on separate chart sheets


Chart Tips

Application.ShowChartTipNames = True 
Application.ShowChartTipValues = True

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext