Layout 6: Layout 6 shows the following elements: Chart Title, Vertical Axis Title, Data Labels on Last Category (Outside End), Horizontal axis, Vertical Axis, and Major Gridlines.

Next, select E11:N11 and Excel applies the formatting from the header to the chart’s title row (Figure J). Once you do, you’ll need to center the chart title again. Figure J ...