Positioning Graphics Evenly

Sometimes you may need to position graphics evenly within a worksheet. For instance, you may have four small graphics that will appear next to each other. You may want to make sure that the graphics are an equal distance from each other. To do this easily within Excel, follow these steps:

1. Using the mouse, roughly position the graphics where you want them to appear. You should make sure that the left-most graphic is where you want it, as is the right-most graphic.
2. Select all four graphics.
3. Make sure the Drawing toolbar is displayed.
4. Click on the Draw option on the Drawing toolbar, and then choose Align or Distribute.
5. Choose Distribute Horizontally from the resulting submenu. Excel positions the two inside graphics so that all four graphics are an equal distance from each other.

Excel 2007 doesn't have a drawing toolbar, of course, so the steps are slightly different:

1. Using the mouse, roughly position the graphics where you want them to appear. You should make sure that the left-most graphic is where you want it, as is the right-most graphic.
2. Select all four graphics. Excel should display the Format tab of the ribbon automatically.
3. Click the Align tool in the Arrange group. Excel displays a list of different ways you can arrange the graphics.
4. Choose Distributing Horizontally. Excel positions the two inside graphics so that all four graphics are an equal distance from each other.