Stacked bar graph of varying widths?

[knaubber23]

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

 

[Guest]

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.

 

[Del Cotter]

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

 

[Jon Peltier]

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

 

[Del Cotter]

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

 

[Jon Peltier]

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

- Jon