Microsoft Office Tutorials and References
In Depth Information
To hide the other lines, select
each in turn and then repeat
the process by pressing
Ctrl + Y. After you do so, your
charts all will display the same
Y-axis values, as illustrated
here.
AB
C
D
E
F
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
Mar-04
Jun-04 Sep-04 Dec-04
Firm 1
2
4
3
6
Firm 2
3
1
4
2
Max
3
4
4
6
Min
2
1
3
2
Firm 1
8
6
4
2
0
Mar-04
Jun-04
Sep-04
Dec-04
Firm 2
8
6
4
2
0
Mar-04
Jun-04
Sep-04
Dec-04
How to Eliminate Un-Wanted Extreme Values
When we force all charts in a
group of charts to use the
same Y-axis values, we need
to have a strategy for handling
values that are unusually large
or small.
AB
C
D
E
F
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
Mar-04
Jun-04 Sep-04 Dec-04
Firm 1
2
4
3
6
Firm 2
3
-15
4
2
Max
3
4
4
6
Min
2
-15
3
2
Firm 1
10
0
-10
-20
Here, for example, Firm 2 had
a value of -15 in Jun-2004,
rather than the value of 1
shown above. This extreme
value makes all other
measures difficult to assess.
Mar-04
Jun-04
Sep-04
Dec-04
Firm 2
10
0
-10
-20
Mar-04
Jun-04
Sep-04
Dec-04
We therefore need a strategy for dealing with extreme values like
this.
For most measures, we can arbitrarily choose the lowest or highest
value of interest. Any values outside this relevant range, are…
well… irrelevant.
Search JabSto ::




Custom Search