I need a barchart that shows, for each time period, two adjacent bars, each
of which is composed of two or more elements (which will stack vertically).
I can do those things separately but there doesn't seem to be a chart type
(either standard or custom) which does this. Can I create a new chart type
or download one from somewhere? I'm using Excel 2003 and am a corporate user
so no immediate hope of an upgrade.

Hi,

Something like this?
http://peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

Tim Spence wrote:
I need a barchart that shows, for each time period, two adjacent bars, each
of which is composed of two or more elements (which will stack vertically).
I can do those things separately but there doesn't seem to be a chart type
(either standard or custom) which does this. Can I create a new chart type
or download one from somewhere? I'm using Excel 2003 and am a corporate user
so no immediate hope of an upgrade.

On Wed, 30 May 2007, in microsoft.public.excel.charting,
Tim Spence said:
I need a barchart that shows, for each time period, two adjacent bars, each
of which is composed of two or more elements (which will stack vertically).
I can do those things separately but there doesn't seem to be a chart type
(either standard or custom) which does this. Can I create a new chart type
or download one from somewhere? I'm using Excel 2003 and am a corporate user
so no immediate hope of an upgrade.


Easy peasy. Make a stacked column chart with four elements, of which two
in any one column have the value zero, like so:

Column1 Column2
Element1 1 0
Element2 2 0
Element3 0 3
Element4 0 4

Excel is more flexible than it looks, and usually the key to new chart
types is just a bit of lateral thinking.

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

Andy - exactly like that. thanks for the link, looks helpful. I'll give it
a go.

Cheers

Tim

"Andy Pope" wrote:

Hi,

Something like this?
http://peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

Tim Spence wrote:
I need a barchart that shows, for each time period, two adjacent bars, each
of which is composed of two or more elements (which will stack vertically).
I can do those things separately but there doesn't seem to be a chart type
(either standard or custom) which does this. Can I create a new chart type
or download one from somewhere? I'm using Excel 2003 and am a corporate user
so no immediate hope of an upgrade.