Del,

Thanks for the reply.

I thought about what you wrote, and that it might be able to work, but just
to get some clarification I will give you some variables:
1. y axies = "1-1000"
2. x axies = "Week 26 - Week 28" (3 series)
The first series would contain 4 solid columns(or a range between "1-1000")
and one stacked column which would make of 3 different ranges(colors) of
"1-1000" The other 2 series would be the same but just a different set of
data.

So would this scenario work with the "Stacked Cluster Graph" This would be
part of a report that is ran once a week.


"Del Cotter" wrote:

On Wed, 2 Jul 2008, in microsoft.public.excel.charting,
Sound Into Words said:
The Graph I'm looking for is kind of like Jon's graph except I'm looking for
3 solid columns and 1 stacked column. All of Jon's columns are stacked on
his graph

Yes, but have you noticed they're stacked with *different* clusters?

The basic insight that leads to being able to do these is that a "solid"
column is just a cluster of one, or a cluster in which every element but
one has the value *zero*. Once you grok that, it all becomes obvious.

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