Hi all,

I have set-up a bar-graph consisting of four horizontal bars. I would like
to overlay one particular bar onto another specific bar - leaving the other
two as is. Is this possible? I have looked at the 'Overlap' option but
unfortunately while this is on the right theme, it overlaps everything!

Any help greatly appreciated!

On Tue, 12 Jun 2007, in microsoft.public.excel.charting,
Don said:
I have set-up a bar-graph consisting of four horizontal bars. I would like
to overlay one particular bar onto another specific bar - leaving the other
two as is. Is this possible? I have looked at the 'Overlap' option but
unfortunately while this is on the right theme, it overlaps everything!

I would put the bar that requires overlap (100%?) on the secondary axis,
and create two dummy (empty) series to join it, which will "overlap" the
other two bars. But since they will be zero, there'll be nothing the
it's just to keep the two sets of bars straight.

If you want a partial overlap, then put the two sets of bars you want to
overlap on the second axis, and juggle dummy series on the first and
second axes until you get it looking right.

Enough dummy series might even let you do it all on one axis.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Del,

Many thanks! That has worked a treat!!
Being pedantic there is one niggly issue :( ... I have included a legend,
and now have two 'dummy' series appearing! Is there an effective way of
removing these from the legend?

Don-

"Del Cotter" wrote:

On Tue, 12 Jun 2007, in microsoft.public.excel.charting,
Don said:
I have set-up a bar-graph consisting of four horizontal bars. I would like
to overlay one particular bar onto another specific bar - leaving the other
two as is. Is this possible? I have looked at the 'Overlap' option but
unfortunately while this is on the right theme, it overlaps everything!

I would put the bar that requires overlap (100%?) on the secondary axis,
and create two dummy (empty) series to join it, which will "overlap" the
other two bars. But since they will be zero, there'll be nothing the
it's just to keep the two sets of bars straight.

If you want a partial overlap, then put the two sets of bars you want to
overlap on the second axis, and juggle dummy series on the first and
second axes until you get it looking right.

Enough dummy series might even let you do it all on one axis.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

On Tue, 12 Jun 2007, in microsoft.public.excel.charting,
Don said:

Many thanks! That has worked a treat!!
Being pedantic there is one niggly issue :( ... I have included a legend,
and now have two 'dummy' series appearing! Is there an effective way of
removing these from the legend?

Yes, if you single-click carefully a few times on one of the offending
legend entries, you should get a selection that affects only that entry.
You can then delete it, leaving the rest of the legend behind.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.