Odd overlapping problem with standard column chart

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 <MJW@discussions.microsoft.com> 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 del@branta.demon.co.uk,
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...sOnTwoAxes.html

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


"Del Cotter" <del@branta.demon.co.uk> wrote in message
news:wUABQ3D7CiwGFwF+@branta.demon.co.uk...
> On Tue, 14 Aug 2007, in microsoft.public.excel.charting,
> MJW <MJW@discussions.microsoft.com> 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
> del@branta.demon.co.uk,
> 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...sOnTwoAxes.html
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______
>
>
> "Del Cotter" <del@branta.demon.co.uk> wrote in message
> news:wUABQ3D7CiwGFwF+@branta.demon.co.uk...
> > On Tue, 14 Aug 2007, in microsoft.public.excel.charting,
> > MJW <MJW@discussions.microsoft.com> 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
> > del@branta.demon.co.uk,
> > 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" <MJW@discussions.microsoft.com> wrote in message
news:B4E4F8FD-6E10-4286-8D17-4C1B0205A597@microsoft.com...
> 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...sOnTwoAxes.html
>>
>> - Jon
>> -------
>> Jon Peltier, Microsoft Excel MVP
>> Tutorials and Custom Solutions
>> Peltier Technical Services, Inc. - http://PeltierTech.com
>> _______
>>
>>
>> "Del Cotter" <del@branta.demon.co.uk> wrote in message
>> news:wUABQ3D7CiwGFwF+@branta.demon.co.uk...
>> > On Tue, 14 Aug 2007, in microsoft.public.excel.charting,
>> > MJW <MJW@discussions.microsoft.com> 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
>> > del@branta.demon.co.uk,
>> > which goes to a spam folder-- please send your email to del3
>> > instead.
>>
>>
>>