Is it possible to create completey new chart types in excel?

[Tim Spence]

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.

 

[Andy Pope]

Hi,

Something like this?
http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

Cheers
Andy

 

[Del Cotter]

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.

 

[Tim Spence]

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

Cheers

Tim