Microsoft Office Tutorials and References
In Depth Information
setting, click anywhere on one chart, as shown in the previous
example. Hold down your Shift key then click on another chart.
When you do so, both charts will display small white circles at their
corners and centers as selection objects. These circles indicate that
the chart objects are selected, not an object within the charts.
In Excel’s menu, choose Format, Object. In the Properties tab,
make sure that Move and Size with Cells is marked. Then choose
OK. You can select as many charts as you want before you apply
Once all the charts are set to size with cells, your charts will change
their size as you change the width of a column or the height of a
When you have several rows or columns of charts that need to be
the same size, you can adjust all of them in the same operation. To
do so, you first select the rows or columns that you’ve designed for
For example, in the figure on the previous page, you would use
column O to adjust the width, and rows 7 and 10 to adjust the
heights. The other rows and columns affect the figures’ formats in
Suppose you want to adjust the widths of columns L, O, and R.
Select any of these columns by clicking in the column header. Hold
down your Ctrl key and select another column. And then, while still
holding down the Ctrl key, select the third column. With three
columns selected you can click and drag any of these to adjust all
three. Or you can choose Format, Column, Width to enter a new
number for the width of all three columns.
Use a similar approach to adjust the row heights.