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