Microsoft Office Tutorials and References
In Depth Information
white. When printed in color, you must answer that question for
yourself.
Row and Column Control
Excel’s rows and columns give you a great
deal of control over the appearance of your
dashboard charts.
K
4
6
Net Profit Margin
7
15%
To see why this is true, examine the row and
column settings for the two figures on this
page.
10%
5%
0%
-5%
8
9
II
III
03
I
II
% of Revenues
Both figures use certain rows to contain
titles and other labels. They use rows and columns to define
borders and white space for the charts. And they rely on the rows
and columns to control the size of the charts.
How to Resize All Your Charts at Once
When you anchor your charts in the
same rows and columns, you can
adjust their heights and widths easily.
MN
O
PQ
Cash Flow
4
6
Net Operating Cash Flow
Billions of $
For example, suppose that your new
report is slightly too tall and too wide
to fit on one printed page. How can
you make it fit?
30
20
10
0
7
00
I
II
III
01
9
Net Investing Cash Flow
Billions of $
The easiest approach to try first is to
reduce the height and width of each
chart by a slight amount. In total,
perhaps, these reductions will save
you from having to redesign your
charts to fit them on the page.
0
-5
-10
10
00
I
II
III
01
For your charts to resize this way they need to be set so they will
move and size with the cells they are anchored to. To apply this
Search JabSto ::




Custom Search