Microsoft Office Tutorials and References
In Depth Information
The Easy Way to Set Up Y-Axis Common
Scaling
There’s an easy way to set up common-scaling. It doesn’t require
maintenance, and it doesn’t require macros. It’s illustrated by the
figure below.
Excel sets the Y-axis scale
values to accommodate the
largest and smallest values
displayed in a chart. Therefore,
to force Excel to scale two
charts in the same way, the
data for each chart needs to
include the same maximum
and minimum values.
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
That is, you create two new
data series with the maximum
and minimum values for the
data displayed in all charts. You copy these two data series to each
chart, and then hide each new pair of data series.
2
0
Mar-04
Jun-04
Sep-04
Dec-04
This approach forces all charts to display the same maximum and
minimum values. It therefore causes Excel to use the same Y-axis
scaling.
Let’s examine these steps more carefully.
Prepare Your Data for Common Charting
The numbers that support your charts often aren’t pretty.
Often, there are rows of source data, complex calculations, error
values, missing data, and so on. The formulas needed to deal with
those issues typically are in another sheet in your workbook.
Search JabSto ::




Custom Search