With a regular bar chart, a bar wil appear for each, say, month on a regular
bar chart. If I define three series on a regular bar chart, I get three bars
for each entry. Can I achieve the same thing on a stacked bar chart. Every
series defined just adds to the stack of the bar.

Hi,

The trick is in knowing how to set out your source data.
Look at Jon Peltier's web site. He has several nice examples.

Dave

"Cheezeman" wrote:

> With a regular bar chart, a bar wil appear for each, say, month on a regular
> bar chart. If I define three series on a regular bar chart, I get three bars
> for each entry. Can I achieve the same thing on a stacked bar chart. Every
> series defined just adds to the stack of the bar.

What is his website?

"Dave Curtis" wrote:

> Hi,
>
> The trick is in knowing how to set out your source data.
> Look at Jon Peltier's web site. He has several nice examples.
>
> Dave
>
> "Cheezeman" wrote:
>
> > With a regular bar chart, a bar wil appear for each, say, month on a regular
> > bar chart. If I define three series on a regular bar chart, I get three bars
> > for each entry. Can I achieve the same thing on a stacked bar chart. Every
> > series defined just adds to the stack of the bar.

Try here:

http://peltiertech.com/Excel/ChartsH...sterStack.html

or Andy's site, here

http://www.andypope.info/charts/stackside.htm

Dave

"Cheezeman" wrote:

> What is his website?
>
> "Dave Curtis" wrote:
>
> > Hi,
> >
> > The trick is in knowing how to set out your source data.
> > Look at Jon Peltier's web site. He has several nice examples.
> >
> > Dave
> >
> > "Cheezeman" wrote:
> >
> > > With a regular bar chart, a bar wil appear for each, say, month on a regular
> > > bar chart. If I define three series on a regular bar chart, I get three bars
> > > for each entry. Can I achieve the same thing on a stacked bar chart. Every
> > > series defined just adds to the stack of the bar.

[Jon_Peltier]

I've updated my Clustered-Stacked Column Chart article, and it's now located at Clustered-Stacked Column Charts.