Excel 2000 Chart Y-Axis Scale break

[-PJ]

I have a mixed bar/line chart where most of the data is in lower numbers
(none higher than 55,000) but one set of data goes up to 110,000. This one
set causes all of the other ones to look very small and the entire top half
of the chart only has that 1 data series. Is there a way to use a smaller
scale and put a break (jagged lines or something like that) in the y-axis
between 60,000 and 100,000 to allow the other data sets to be a little more
visible? Thanks!

 

[Jim Cone]

You could use a chart with two axis...make a duplicate of your data and
add the duplicate series to the chart.
Plot one series on the left axis an the other on the right axis.
Format the appropriate parts of each series to have no fill and no borders.
You end up with what appears to be one series with part of it scaled to
the right axis and the other to the left axis.
You could color each axis to match the appropriate data points.
-or-
Jon Peltier has instructions on creating a "Broken Y Axis" chart here...
http://peltiertech.com/Excel/Charts/index.html#hdrAxes
(under the Chart Axes and Axis Tricks)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"-PJ" <[email protected]>
wrote in message
I have a mixed bar/line chart where most of the data is in lower numbers
(none higher than 55,000) but one set of data goes up to 110,000. This one
set causes all of the other ones to look very small and the entire top half
of the chart only has that 1 data series. Is there a way to use a smaller
scale and put a break (jagged lines or something like that) in the y-axis
between 60,000 and 100,000 to allow the other data sets to be a little more
visible? Thanks!