How do you do a stacked column chart with 2 stacks and 1 line above
the columns plotting values. This line doesn't touch the columns.
This chart has 2 axis.

Thanks for any help on this.

Hello Jay:

Which version of Excel are you using? The answer is different for the
different versions.
--
Hope this helps
Martin Fishlock, www.nyfconsultants.com, Bangkok, Thailand
Please do not forget to rate this reply.


"(E-Mail Removed)" wrote:

> How do you do a stacked column chart with 2 stacks and 1 line above
> the columns plotting values. This line doesn't touch the columns.
> This chart has 2 axis.
>
> Thanks for any help on this.
>

Jay,

First make the stacked column chart. Right-click one of the columns of the series you want
to convert to line. Select Chart type in the menu and select Line. You may want to set it
to the other value (Y) axis to get it scaled suitably.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
<(E-Mail Removed)> wrote in message
news:e28597e2-f9f0-4d94-a8ea-(E-Mail Removed)...
> How do you do a stacked column chart with 2 stacks and 1 line above
> the columns plotting values. This line doesn't touch the columns.
> This chart has 2 axis.
>
> Thanks for any help on this.

Hi Martin,

I am using 2003. I also meant that there is the horizontal axis and 2
vertical axis.
The stacked columns have 2 stacks and on top a line which doesn't
touch the columns.

Hope that makes sense.

Thanks for your help in advance.

On Apr 19, 4:11*pm, Martin Fishlock
<martin_fishl...@yahoo.co.uk.cutthis> wrote:
> Hello Jay:
>
> Which version of Excel are you using? The answer is different for the
> different versions.
> --
> Hope this helps
> Martin Fishlock,www.nyfconsultants.com, Bangkok, Thailand
> Please do not forget to rate this reply.
>
>
>
> "jayrodr...@hotmail.com" wrote:
> > How do you do a stacked column chart with 2 stacks and 1 line above
> > the columns plotting values. This line doesn't touch the columns.
> > This chart has 2 axis.
>
> > Thanks for any help on this.- Hide quoted text -
>
> - Show quoted text -

Hi Earl,

Thanks! That worked great. I forgot to mention before that the chart I
need is a stacked column chart with 2 y axis.
Do I use the normal stacked column chart? or is there a better chart
for this? I tried using the Line Column on 2 axis chart
but I could not stack those columns.

Thanks for your help,
Jay

On Apr 19, 7:00*pm, "Earl Kiosterud" <some...@nowhere.com> wrote:
> Jay,
>
> First make the stacked column chart. Right-click one of the columns of theseries you want
> to convert to line. *Select Chart type in the menu and select Line. *You may want to set it
> to the other value (Y) axis to get it scaled suitably.
> --
> Regards from Virginia Beach,
>
> Earl Kiosterudwww.smokeylake.com
> -----------------------------------------------------------------------<jayrodr...@hotmail.com> wrote in message
>
> news:e28597e2-f9f0-4d94-a8ea-(E-Mail Removed)...
>
>
>
> > How do you do a stacked column chart with 2 stacks and 1 line above
> > the columns plotting values. This line doesn't touch the columns.
> > This chart has 2 axis.
>
> > Thanks for any help on this.- Hide quoted text -
>
> - Show quoted text -

Jay,

There are only two y axes. If you're already using them both, then probably the only thing
left is to scale a series to fit an existing axis. I looked through Joh Peltier's site
(he's the charting guru), http://peltiertech.com/Excel/Charts/index.html, but didn't see
anything that might help.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
<(E-Mail Removed)> wrote in message
news:6cfa477e-1fba-4758-9e52-(E-Mail Removed)...
Hi Earl,

Thanks! That worked great. I forgot to mention before that the chart I
need is a stacked column chart with 2 y axis.
Do I use the normal stacked column chart? or is there a better chart
for this? I tried using the Line Column on 2 axis chart
but I could not stack those columns.

Thanks for your help,
Jay

On Apr 19, 7:00 pm, "Earl Kiosterud" <some...@nowhere.com> wrote:
> Jay,
>
> First make the stacked column chart. Right-click one of the columns of the series you want
> to convert to line. Select Chart type in the menu and select Line. You may want to set it
> to the other value (Y) axis to get it scaled suitably.
> --
> Regards from Virginia Beach,
>
> Earl Kiosterudwww.smokeylake.com
> -----------------------------------------------------------------------<jayrodr...@hotmail.com>
> wrote in message
>
> news:e28597e2-f9f0-4d94-a8ea-(E-Mail Removed)...
>
>
>
> > How do you do a stacked column chart with 2 stacks and 1 line above
> > the columns plotting values. This line doesn't touch the columns.
> > This chart has 2 axis.
>
> > Thanks for any help on this.- Hide quoted text -
>
> - Show quoted text -