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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...


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.
 
Andy - exactly like that. thanks for the link, looks helpful. I'll give it
a go.

Cheers

Tim
 
Back
Top