Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
variable height variable width stacked bar charts
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
variable height variable width stacked bar charts
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
variable height variable width stacked bar charts
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
variable height variable width stacked bar charts
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I print a sheet without the height & width being adjusted | Excel Discussion (Misc queries) | |||
Stacked charts misalign when printed | Charts and Charting in Excel | |||
Vary column width and row height in the same worksheet | Excel Discussion (Misc queries) | |||
Stacked Charts w/ Vertical Separation | Charts and Charting in Excel | |||
Displaying column width and row height | Excel Worksheet Functions |