Add a circle, square, or other AutoShape

You can add AutoShapes and other drawing objects only to a chart. You cannot add them to the datasheet.

  1. On the Drawing toolbar, click AutoShapes, point to a category, and then click the shape you want.

  2. To insert a shape with a predefined size, click the chart.

    To insert a shape with a different size, drag the pointer to make the shape the size you want.

    To maintain the shape's width-to-height ratio, hold down SHIFT while you drag the pointer.


  • To draw a circle or square, click Oval Button image or Rectangle Button image on the Drawing toolbar, and then click the chart.

  • To add color, change borders, rotate, or add shadow or 3-D effects to a shape, select the shape, and then use the tools on the Drawing toolbar.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.