Microsoft Office Tutorials and References
In Depth Information
Forcing Charts to Work Together
Excel charts don’t share, or play well with others. By design, in fact,
two charts on the same worksheet are completely independent of
each other. That can be a problem when two or more charts are
related in some way.
To illustrate, this figure is from a report that shows one table and
four charts for each of seven competitors—all on one page. The
figure shows the first two columns of charts. The other two, which
aren’t shown, are the Debt to Equity Ratio and Return On Equity.
A
BCDEF
GHI
J
K
L
M
4
6
8
9
10
11
12
13
14
15
1 17
Quarter to Quarter
Profits on Sales
Assets Turnover
1.
Sodexho, Inc.
2-00
15%
4.0
1
10%
2-01 Δ %
3.0
5%
Profit %:
- % -
0%
2.0
Turnover:
- .2 -
-5%
1.0
-10%
Debt Ratio:
-4.23
-4.98
-0.76
-15%
.0
-1
ROE:
- 1% -
Dec
Mar
Jun
Sep Dec
Dec
Mar
Jun
Sep
Dec
2.
Panera Bread Company
12-00 12-01 Δ %
19
20
21
22
23
24
2 26
15%
4.0
1
10%
3.0
5%
Profit %:
3%
7%
4%
0%
2.0
Turnover:
1.47
1.40
-0.07
-5%
1.0
-10%
Debt Ratio:
0.22
0.20
-0.02
-15%
.0
-1
ROE:
5% 11%
7%
Dec
Mar
Jun
Sep Dec
Dec
Mar
Jun
Sep
Dec
General Formatting Issues
The headings in rows 6 and 7 use text boxes with static text. This
makes it easy to position the headings where they look best.
Although this figure doesn’t emphasize the fact, the maroon line in
row 5 is thicker than the other two horizontal lines. Row 5 can be as
thick as necessary, because the range B5:M5 in the figure applies
maroon color to the cells, and row 5 has a height of only 3 units.
 
Search JabSto ::




Custom Search