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
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext