Microsoft Office Tutorials and References
In Depth Information
Set Up Max and Min Data Series for Each Chart
Once the Max and Min values
are set up in your spreadsheet,
you copy them to your chart.
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
In this figure, for example, you
would copy the range B4:F5 to
the Chart Area of each chart.
After you do so, your charts
probably will look something
like these.
Firm 1
8
6
4
2
0
Mar-04
Jun-04
Sep-04
Dec-04
Firm 2
8
6
4
2
Although the new data series
obscure your original data
area, you can see that the two Y-axis values now are in sync.
0
Mar-04
Jun-04
Sep-04
Dec-04
You take two steps to hide these new series. The first step is to
convert the area charts to line charts. This step isn’t really
necessary. But it’s useful because it keeps the two new series from
obscuring the data area. This can be a useful benefit when we’re
setting up these charts.
To convert the area charts to line charts, choose one of the area
data series as shown in the figure above. Choose Chart, Chart
Type. In the Standard Types tab of the Chart Type dialog, choose
the Line chart type, and the top-left Chart sub-type. Then choose
OK.
To convert the other area chart, select it in your chart then choose
Edit, Repeat Chart Type, or else press Ctrl + Y. Repeat this step for
your other common-scaled charts.
To hide the lines, select one of the lines in one of the charts.
Choose Format, Selected Data Series. In the Patterns tab choose
the Line setting of None, and the Marker setting of None. Then
choose OK.
Search JabSto ::




Custom Search