Bar Graphs

[Don]

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!

 

[Del Cotter]

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 there:
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.

 

[Don]

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]

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.