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.

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

http://peltiertech.com/Excel/Charts/VarWidthColumn.html
http://peltiertech.com/Excel/ChartsH...thColumns.html
http://pubs.logicalexpressions.com/P...cle.asp?ID=508


--
--
@+
;o)))

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

"Mais qui est Paul" wrote:

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/ChartsH...thColumns.html
http://pubs.logicalexpressions.com/P...cle.asp?ID=508


--
--
@+
;o)))

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Dion" wrote in message
...
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

"Mais qui est Paul" wrote:

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/ChartsH...thColumns.html
http://pubs.logicalexpressions.com/P...cle.asp?ID=508


--
--
@+
;o)))