software

This may be a FAQ, but I cannot find/figure it out.

I have several series of data, which I am stacking up
on top of each other in a column chart, for different
X-axis categories.

The first series numbers are very large, the later ones
become mostly increasingly small.

I would like to focus the chart on the top end, and not
extend it all the way to the x-axis, as thus the very large
series-one columns would take up most of the chart,

Now, I know I can set the 'minimum' on the y-axis to
some value (and thus 'lose' most of the series-1
stacks in the graph), but that would mean that visually
there is no real indication that the chart has been 'cut-off'.

Is there any way I can display some 'rip effect' like thus:

120-| |---| |---|
110-| |---| |@@@| |:::|
100-| |:::| |---| |:::|
90-| |:::| |:::| |:::|
/\/\/\/\/\/\/\/\/\/\/\/\/
/\/\/\/\/\/\/\/\/\/\/\/\/
10-| |:::| |:::| |:::|
0- ---------------------
1 2 3

which would visually indicate that there is a whole lot of
y-axis missing?

Any help how to accomplish this would be welcome.
So would be hints as to better describe this feature
(are there terms for this), so I can google more effectively?

PS: is there a charting FAQ for Excel?

MHi,

Here are some links on the subject of broken axis.

peltiertech.com/Excel/Charts/BrokenYAxis.html
tushar-mehta.com/excel/newsgr...ial/index.html
www.andypope.info/charts/brokencolumn.htm

Check out the Link pages on the sites for other Excel/charting related
sites.

Cheers
Andy

Mathias Koerber wrote:
gt; This may be a FAQ, but I cannot find/figure it out.
gt;
gt; I have several series of data, which I am stacking up
gt; on top of each other in a column chart, for different
gt; X-axis categories.
gt;
gt; The first series numbers are very large, the later ones
gt; become mostly increasingly small.
gt;
gt; I would like to focus the chart on the top end, and not
gt; extend it all the way to the x-axis, as thus the very large
gt; series-one columns would take up most of the chart,
gt;
gt; Now, I know I can set the 'minimum' on the y-axis to
gt; some value (and thus 'lose' most of the series-1
gt; stacks in the graph), but that would mean that visually
gt; there is no real indication that the chart has been 'cut-off'.
gt;
gt; Is there any way I can display some 'rip effect' like thus:
gt;
gt; 120-| |---| |---|
gt; 110-| |---| |@@@| |:::|
gt; 100-| |:::| |---| |:::|
gt; 90-| |:::| |:::| |:::|
gt; /\/\/\/\/\/\/\/\/\/\/\/\/
gt; /\/\/\/\/\/\/\/\/\/\/\/\/
gt; 10-| |:::| |:::| |:::|
gt; 0- ---------------------
gt; 1 2 3
gt;
gt; which would visually indicate that there is a whole lot of
gt; y-axis missing?
gt;
gt; Any help how to accomplish this would be welcome.
gt; So would be hints as to better describe this feature
gt; (are there terms for this), so I can google more effectively?
gt;
gt; PS: is there a charting FAQ for Excel?
gt;
gt; M
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info