Broken Y Axis in Line Chart
 

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

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,