Hi,
Can you not make use of the second example on this page.
http://www.andypope.info/charts/colwidth2.htm
Cheers
Andy
ambthiru wrote:
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
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info