variable height variable width stacked bar charts

[ambthiru]

Hi

I need to create a chart which would resemble a
variable width variable height stacked bar chart with
values on both sides of the Y axis (This I achieved by
giving values needed on the left a negative sign). I
tried to get the above chart using all these basic
charts in excel - stacked bar charts, stacked column
charts,stacked area charts, stacked scatter plots but
could not get the final chart. Though I was able to
get a variable height stacked bar chart(with pos n neg
values), I am not able to get the final desired chart.
Please let me know how I can get the above mentioned
chart.

Thanks
Ambika Thiruvengada

 

[Andy Pope]

Hi,

Can you not make use of the second example on this page.
http://www.andypope.info/charts/colwidth2.htm

Cheers
Andy

 

[ambthiru]

I did try with the example you had pointed out but couldnt get the fina
chart ....

Ambika

 

[Jon Peltier]

I used a stacked area chart technique to simulate a stacked bar (no, not
column!) in this example:



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



Perhaps you can follow this example to get what you need.



- Jon

-------

Jon Peltier, Microsoft Excel MVP

Peltier Technical Services

Tutorials and Custom Solutions

http://PeltierTech.com/

_______