How to change the layout of the Excel chart. ... Layout 1: Layout 1 shows the following elements: Chart Title, Legend (Right), 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 ...