Broken Y Axis in Line Chart

[raycyn.wright]

Is it possible to create the broken Y-Axis on a Line Chart? A logarithmic
axis is not appropriate form my data and I do not want to create a secondary
axis (confusing for the reader). I have looked at the methods described by
Jon Peltier, Andy Pope, and Tushar Mehta and (if I understand them
correctly) they work for column charts and scatter plots respectively. I
understand these techniques but my data is categorical (months on X-axis)
and numerical on the Y-axis. A column chart is an option but does not
convey the temporal trends ant I wish to illustrate.



Any and all advice appreciated,




--
Ray Wright
[email protected]

[Jon Peltier]

You can apply my broken axis technique to a line chart, but don't put
the break within the chart itself as you would to indicate a broken
column. Instead, you can indicate a break by formatting an individual
line segment that crosses the break with a dashed line instead of a
solid line.

raycyn.wright wrote:

> Is it possible to create the broken Y-Axis on a Line Chart? A logarithmic
> axis is not appropriate form my data and I do not want to create a secondary
> axis (confusing for the reader). I have looked at the methods described by
> Jon Peltier, Andy Pope, and Tushar Mehta and (if I understand them
> correctly) they work for column charts and scatter plots respectively. I
> understand these techniques but my data is categorical (months on X-axis)
> and numerical on the Y-axis. A column chart is an option but does not
> convey the temporal trends ant I wish to illustrate.
>
>
>
> Any and all advice appreciated,
>
>
>
>