1.If the diagram is in a document or a worksheet, double-click on the diagram to open it.

2.Double-click on the legend title, edge of the legend or diagram surface, but not on a curve in the legend.

3.In the Properties dialog box click on the Legend tab, if necessary.

4.Under Layout enter the desired value in the Number of columns field.

5.You can adjust the arrangement of the entries using the Arrange entries line by line option.

See Also

Legend