varying y-axis

i have 2 data sets with large discrepencies in values. i want to make a
bar graph with the smaller set directly on top of the larger set, but if
i do this, you can barely see the smaller set. i know that a log scale
would work for this, but that's not what i need. is there a way to
split the y-axis on a bar chart like there is for a scatter plot. that
way the first bar could go up to, say 100, increments of 10, then there
be a break in the y-axis and skip to 100,000. i would also need the
increments to then increase after the split, say to 10,000. this seems
relatively simple, but i can't seem to figure it out. thanks a lot.


--
etraleigh

I'm guessing you are looking for something like this

http://www.peltiertech.com/Excel/Cha...kedCharts.html

"etraleigh" wrote:


i have 2 data sets with large discrepencies in values. i want to make a
bar graph with the smaller set directly on top of the larger set, but if
i do this, you can barely see the smaller set. i know that a log scale
would work for this, but that's not what i need. is there a way to
split the y-axis on a bar chart like there is for a scatter plot. that
way the first bar could go up to, say 100, increments of 10, then there
be a break in the y-axis and skip to 100,000. i would also need the
increments to then increase after the split, say to 10,000. this seems
relatively simple, but i can't seem to figure it out. thanks a lot.


--
etraleigh