Odd overlapping problem with standard column chart

[MJW]

Hi All,

While I've never had a problem with this in the past, this isn't the past...
currently, I'm working on a large-scale metrics project, and nearly
everything has gone smoothly. However, now, every time I try to create a
column chart with multiple y-axes, it overlaps the columns. I've tried
changing the sources to both Pivot and standard table forms, I've tried
changing the overlap and gap values on the data series for both sources, I've
even tried changing it and reverting it to see if it was maybe a bug--no
results. I've never once had this problem, and it's more than slightly
annoying. Anyone? Bueller? Bueller?

Thanks,

Jamie

 

[Del Cotter]

While I've never had a problem with this in the past, this isn't the past...
currently, I'm working on a large-scale metrics project, and nearly
everything has gone smoothly. However, now, every time I try to create a
column chart with multiple y-axes, it overlaps the columns.

Is it completely 100% overlap, or just a little bit?

I've tried changing the overlap and gap values on the data series for
both sources

Have you got two column series on different y-axes? If so, then you'll
need to insert some dummy series with no data, just to give the two bars
a bit of room for each other. See the responses to the question a couple
of days ago titled "Secondary axis."

 

[Jon Peltier]

Or see the example solution on this page:

http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html

- Jon

 

[MJW]

It's actually 100% overlap--even if I set it to -100. I was wondering if it
was charting the smaller series at all, until I changed the gaps on the
larger value and found the smaller series hiding behind it. Tried that link,
but it doesn't seem to cover what's happening with mine. Creating a dummy
series wouldn't work either, unfortunately, because it would just cause that
to overlap as well. It's really odd, I've never seen this happen before and
have no idea what's causing it.

Thanks

Jamie W.

(The only ITA/BA who can cause system mutations by mere proximity. Talk
about a useless ability--couldn't I just be a mind-reader or ability to fly?
What luck.)

 

[Jon Peltier]

Try the protocol in the link I cited. You have offsetting dummy series, so
the dummy series on the primary axis overlaps the real series on the
secondary, and vice versa.

- Jon