Microsoft Office Tutorials and References
In Depth Information
Overlaid Charts
Excel area charts are displayed on top of
gridlines, not behind them. So how did I
create this Excel chart with gridlines on
top?
10
1.0
10
1.0
0.8
8
8
0.8
6
0.6
6
0.6
0.4
4
4
0.4
2
2
0.2
0.2
0
0
0.0
0.0
Jan
04
Jan
04
Apr
Apr
Jul
Jul
Oct
Oct
Jan
05
Jan
05
Considering this section title, the answer
must have something to do with overlaid
charts.
The previous figure was made up of
these two chart objects, with the second
of these placed exactly on top of the
first.
1.0
10
8
0.8
6
0.6
0.4
4
2
0.2
0
0.0
Jan
04
Apr
Jul
Oct
Jan
05
By overlaying the two chart objects, I
created one image with the gridlines on
top.
10
1.0
This solution offers the only way to
present one chart figure that displays
chart items on top of items that Excel
normally displays beneath.
8
0.8
6
0.6
4
0.4
2
0.2
0
0.0
Jan
04
Apr
Jul
Oct
Jan
05
To set up this effect, first create one
chart object with all formatting and data required by both charts.
Then copy the chart object.
In the first chart object, hide all unnecessary chart items. Hide
borders and data series by formatting the patterns for the borders
and areas as None. For fonts, set their color to that of the chart’s
background color, usually white. Also set the font’s background
color to Transparent. After you hide each object, the first chart will
look somewhat like the top figure above.
 
Search JabSto ::




Custom Search