Format Chart

How can you format a chart with:
adding Gridline
remove legend
changing Axis TickLabel orientation
change Plotarea background color
in less than 5 second?

Yes, you can, with the following VBA code


'' Format Chart Look
With ActiveChart
.PlotArea.Interior.ColorIndex = 2
With .Axes(xlCategory)
.TickLabels.Alignment = xlCenter
.TickLabels.Orientation = xlUpward
.AxisBetweenCategories = False
.HasMajorGridlines = True
End With
.HasTitle = True
.ChartTitle.Text = testParam
.HasLegend = False

End With