Broken Y Axis in Line Chart

R

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,
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top