Width of columns in EXcel

A client of mine has asked if it is possible in Excel
(2002) to make a bar chart, where the width of each bar is
proportionate to the value of it's point data.

I have tried without success

Any help would be appreciated

Thanks
Lynne

Lynne wrote:
A client of mine has asked if it is possible in Excel
(2002) to make a bar chart, where the width of each bar is
proportionate to the value of it's point data.

I have tried without success

I do not know an easy way to do it. It would be possible to draw each of
the bars (columns) by yourself using an XY scatter chart, scaling the width
of the bar along with the height. But filling the columns with colors and
patterns might be a real chore....

Dave
dvt at psu dot edu

Lynne -

This isn't a straightforward procedure, but Stephen Bullen shows how to
do this in the FunChart5.xls example on his web site (http://bmsltd.co.uk).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Lynne wrote:
A client of mine has asked if it is possible in Excel
(2002) to make a bar chart, where the width of each bar is
proportionate to the value of it's point data.

I have tried without success

Any help would be appreciated

Thanks
Lynne

You should also note that doing this would be a classic form of "How to
Lie with Statistics"

Jon Peltier wrote:
Lynne -

This isn't a straightforward procedure, but Stephen Bullen shows how to
do this in the FunChart5.xls example on his web site (http://bmsltd.co.uk).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Lynne wrote:

A client of mine has asked if it is possible in Excel (2002) to make a
bar chart, where the width of each bar is proportionate to the value
of it's point data.

I have tried without success

Any help would be appreciated

Thanks
Lynne



--
Gary Klass

Editor, PSRT-L
4600 Politics and Government
Illinois State University
Normal, Illinois 61790
http://LILT.ILSTU.EDU/gmklass
(309) 438-7852
(fax) 438-7638
The Chart of the Week: http://LILT.ILSTU.EDU/gmklass/cow

It's not lying if it gets you what you want.

- Jon

Gary Klass wrote:
You should also note that doing this would be a classic form of "How to
Lie with Statistics"

Jon Peltier wrote:

Lynne -

This isn't a straightforward procedure, but Stephen Bullen shows how
to do this in the FunChart5.xls example on his web site
(http://bmsltd.co.uk).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Lynne wrote:

A client of mine has asked if it is possible in Excel (2002) to make
a bar chart, where the width of each bar is proportionate to the
value of it's point data.

I have tried without success

Any help would be appreciated

Thanks
Lynne