I'm creating a line chart with data that is mostly similar (values are around
10,000 each) but then one line of my data is huge (around 14,000,000). What
I'd like to do is have all of this data on the same chart, but when I do
that, it makes all the 10,000ish data extremely small and close together at
the bottom in order to make room on the chart for the 14,000,000 item on the
x-axis. Is there a way to make the axis skip from around 20,000 to
13,900,000 for example (an area that would be blank on the chart as it is
now), to be able to show detail for all lines?

http://peltiertech.com/Excel/Charts/BrokenYAxis.html
--
David Biddulph

"Sam" wrote in message
...
I'm creating a line chart with data that is mostly similar (values are
around
10,000 each) but then one line of my data is huge (around 14,000,000).
What
I'd like to do is have all of this data on the same chart, but when I do
that, it makes all the 10,000ish data extremely small and close together
at
the bottom in order to make room on the chart for the 14,000,000 item on
the
x-axis. Is there a way to make the axis skip from around 20,000 to
13,900,000 for example (an area that would be blank on the chart as it is
now), to be able to show detail for all lines?