Stacked bar graph of varying widths?

  • Thread starter Thread starter knaubber23
  • Start date Start date
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.
 
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.
Click to expand...

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
 
Back
Top