How to change format for diagram shapes in Excel

Excel 2016
The Shape Format tab (the Format tab of the Drawing Tools toolbar in Excel 2016) provides plenty of options for customizing a shape outline, background, and text settings. Also, you can change spacing and size for multiple shapes at once.

To change the format of the flowchart shape or the diagram shape, do the following:

   1.   Select one shape or multiple shapes.

When you select a shape, Excel displays the Shape Format tab:

Shape Format tab in Excel 365
  • The WordArt Styles group contains commands for creating and modifying the WordArt text inside a shape.
  • The Arrange group allows you to:
    • adjust the "stack order" of shapes,
    • align shapes,
    • group, regroup, and ungroup multiple shapes,
    • rotate shapes.
  • The Size group allows you to change the size of a shape by typing dimensions.

   2.   Do one of the following:

  • On the Shape Format tab, in the Shape Styles group, click the dialog box launcher:
    Shape Styles group in Excel 365
  • Right-click on the selected shape and choose Format Shape... in the popup menu:
    Format Shape popup in Excel 365

    On the Format Shape pane, choose format options:

    Format Shape pane in Excel 365

See also this tip in French: Comment modifier le format des formes de diagramme dans Excel.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.