canasia.org

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 Thiruvengadam

I used a stacked area chart technique to simulate a stacked bar (no, not column!) in this example:   http://pubs.logical_expression_s.com/Pub0009/LPMArticle.asp?ID=533 Perhaps you can follow this example to get what you need. - Jon