improved chart in Excel

[Dion]

Good day, I am looking for a way to create bar charts in Excel where the
width of the bar can be varied according to a variable.

For example the Y axis would show Exports Per Capita for a number of
cvountries, the X axis would give the Population of each country shown. Thus
the area of each bar (or column) would give total Exports.

Any tips would be appreciated.

 

[Mais qui est Paul]

Bonsour® Dion avec ferveur ;o))) vous nous disiez :

Good day, I am looking for a way to create bar charts in Excel where
the width of the bar can be varied according to a variable.

For example the Y axis would show Exports Per Capita for a number of
cvountries, the X axis would give the Population of each country
shown. Thus the area of each bar (or column) would give total Exports.

Any tips would be appreciated.

Approuved Tips !!!
http://www.andypope.info/charts/colwidth2.htm

http://peltiertech.com/Excel/Charts/VarWidthColumn.html
http://peltiertech.com/Excel/ChartsHowTo/VariableWidthColumns.html
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=508

 

[Dion]

Merci!
I was aware of these, but these are roundabout artisanal shortcuts. What is
missing is an analytical tool which enables you to vary the width of the bars
to reflect some other variable. If there was a way to attach files to
messages here i could explain better what capability I am looking for.
Salut!
Dion

 

[Jon Peltier]

We know what you're looking for. Your options are to use these "roundabout
artisanal shortcuts" or nothing at all.

- Jon