Stacked bar graph of varying widths?

knaub...@yahoo.com

unread,

Jun 15, 2007, 4:33:25 PM6/15/07

to

How do I make a stacked bar graph of varying widths?

ShaneDevenshire

unread,

Jun 15, 2007, 11:59:00 PM6/15/07

to

Hi,

There is no built in chart for that, however you can create a chart that
accomplishes the same thing. For example the data area shown below will
create such a chart assuming you are doing a column chart. The number of
amount entries per month controls the width of the bars. Then you choose the
series and set the gap width to 0 and set Borders to None.

Month Amount
Jan 15
15

Feb 10

22
Mar 22
22

Apr 35

18
May 18
18
18

Jun 28

Of course you didn't tell us the type of chart, so I assumed a column chart,
and you didn't tell us what factor controlled the bar width.

--
Cheers,
Shane Devenshire

Del Cotter

unread,

Jun 16, 2007, 4:57:37 AM6/16/07

to

On Fri, 15 Jun 2007, in microsoft.public.excel.charting,
ShaneDevenshire <ShaneDe...@discussions.microsoft.com> said:
>There is no built in chart for that, however you can create a chart that
>accomplishes the same thing. For example the data area shown below will
>create such a chart assuming you are doing a column chart. The number of
>amount entries per month controls the width of the bars. Then you choose the
>series and set the gap width to 0 and set Borders to None.

There is a more flexible alternative, described by Jon Peltier in this
TechTrax article:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=508

His example is a matrix graph, that has no gaps between the
variable-width stacked bars, but it's not hard to adapt it for gaps if
you want to. Also, the matrix graph has constant total height of the
stacked blocks, but they can easily be different heights.

It's basically an Excel Stacked Area Chart with a Time-scale X-axis,
where the areas have been made to look like rectangles, as in a bar
chart. Using this approach, the widths can be more finely controlled
without a large number of rows, and the borders don't have to be set to
None.

This much more complicated example by Jon Peltier uses the same
technique to create a *horizontal* floating bar chart with variable
width bars.

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=533

--
Del Cotter
NB Personal replies to this post will send email to d...@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.

Jon Peltier

unread,

Jun 17, 2007, 2:23:00 PM6/17/07

to

This article shows a further use of the technique, which is like a Gantt
chart with variable thickness bars:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=533

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

"Del Cotter" <d...@branta.demon.co.uk> wrote in message
news:IsCP+$BBY6c...@branta.demon.co.uk...

Del Cotter

unread,

Jun 17, 2007, 2:58:08 PM6/17/07

to

On Sun, 17 Jun 2007, in microsoft.public.excel.charting,
Jon Peltier <jonxl...@SPAMpeltiertech.com> said:
>This article shows a further use of the technique, which is like a Gantt
>chart with variable thickness bars:
>
>http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=533

Look again, Jon, near the bottom of my post.

You weren't going to catch me like that a second time :-)

>"Del Cotter" <d...@branta.demon.co.uk> wrote

Jon Peltier

unread,

Jun 17, 2007, 4:18:29 PM6/17/07

to

D'oh!! How did I miss that??

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

"Del Cotter" <d...@branta.demon.co.uk> wrote in message

news:SejpizAA...@branta.demon.co.uk...