Odd overlapping problem with standard column chart

M

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
 
D

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."
 
M

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.)
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top