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


--
ambthiru
------------------------------------------------------------------------
ambthiru's Profile: http://www.hightechtalks.com/m746
View this thread: http://www.hightechtalks.com/t2334639

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

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

Ambika


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


--
ambthiru
------------------------------------------------------------------------
ambthiru's Profile: http://www.hightechtalks.com/m746
View this thread: http://www.hightechtalks.com/t2334639

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



http://pubs.logicalexpressions.com/P...cle.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/

_______

"ambthiru" wrote in message
...

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


--
ambthiru
------------------------------------------------------------------------
ambthiru's Profile: http://www.hightechtalks.com/m746
View this thread: http://www.hightechtalks.com/t2334639