In the Chart Layouts group within the Design tab, select the required chart layout. For example, select Layout 10, which positions the chart legend to the right of the chart area, and adds the chart and axis titles.
To enter the chart title, right-click the chart and select the Change Chart Title... item in the context menu.
In the invoked Change Chart Title dialog box, enter a title and click OK.
To provide horizontal or vertical axis titles, right-click the chart and select the Change Horizontal Axis Title... or Change Vertical Axis Title... item in the context menu. Type a new title in the invoked dialog box.
The image below shows the result.
In the Chart Styles group of the Design tab, click the chart style you wish to apply.
The image below shows a chart with Style 22 applied.
