improved chart in Excel

  • Thread starter Thread starter Dion
  • Start date Start date
D

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

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
 
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
 
We know what you're looking for. Your options are to use these "roundabout
artisanal shortcuts" or nothing at all.

- Jon
 
Back
Top