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

On Tue, 14 Aug 2007, in microsoft.public.excel.charting,
MJW said:
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."

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

Or see the example solution on this page:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Del Cotter" wrote in message
...
On Tue, 14 Aug 2007, in microsoft.public.excel.charting,
MJW said:
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."

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

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" wrote:

Or see the example solution on this page:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Del Cotter" wrote in message
...
On Tue, 14 Aug 2007, in microsoft.public.excel.charting,
MJW said:
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."

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

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"MJW" wrote in message
...
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" wrote:

Or see the example solution on this page:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Del Cotter" wrote in message
...
On Tue, 14 Aug 2007, in microsoft.public.excel.charting,
MJW said:
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."

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