microsoft excel course - Chart

Individual elements of a chart cannot be formatted en bloc without using a custom chart type; basically a template you have set up yourself previously. Essentially, you format a previous chart into the style you want and save this as a user-defined custom chart in the "Chart Type" dialog box and the "Custom Types" tab. Once you've done that, you can right click on any chart, select your custom chart and the chart, including all individual elements, will be formatted accordingly.