$$Excel-Macros$$ How do I create this type of chart?
I don't know what this type of chart this would be called and I was not able to find it in the chart selections in Excel. But I want to create a chart with the following criteria. 1. Percentages from 0% to 100% along the left side of the chart 2. A bar from 25% to 75%. This is the hit area. 3. A horizontal line marking the actual value. For example, the bar will remain fixed from 25% to 75%. The horizontal line would represent any value between 0% to 100%. Thanks, --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Risk Graphs
This is perfect. Thank you so much. On Apr 12, 6:07 pm, Tom Jeffries wrote: > If you want the y-axis (vertical) to change dynamically check the "Auto" > box on the y-axis scale tab. The x-axis (horizontal) will change > automatically based on stock values. > The attached spreadsheet creates a simple risk graph for put and call > options. > > If you have any questions let me know. > > Tom > > On Fri, Apr 10, 2009 at 9:40 PM, mother wrote: > > > Yes, this is what I am looking for. > > I guess the X-axis is fixed and cannot dynamically adjust. > > > Now I have to figure out how to do this with an Option (put or call). > >http://www.optiontradingpedia.com/option_trading_risk_graphs.htm > > I'm not interested in the option combos, but just one option (put or > > call). > > > Thanks, > > > On Apr 10, 6:36 pm, Tom Jeffries wrote: > > > Take a look at the attached spreadsheet. I think it does what you want. > > If > > > you have any questions let me know. > > > Tom Jeffries > > > > On Fri, Apr 10, 2009 at 8:44 AM, mother wrote: > > > > > I'm trying to figure out how to create a Simple Risk Graph (profit/ > > > > lost diagram) like the one described at Investopedia: > > > > >http://www.investopedia.com/articles/optioninvestor/05/012605.asp > > > > > I do not want the add all the extra complexity of stuff. Just a > > > > simple/basic Risk Graph. > > > > > Could someone help me with this? > > > > > If this is not the correct group to post this to, please recommend a > > > > group. > > > > > Thanks, > > > > RiskGraph.xls > > > 23KViewDownload- Hide quoted text - > > > > - Show quoted text - > > > > Option RiskGraph.xls > 24KViewDownload --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Risk Graphs
Yes, this is what I am looking for. I guess the X-axis is fixed and cannot dynamically adjust. Now I have to figure out how to do this with an Option (put or call). http://www.optiontradingpedia.com/option_trading_risk_graphs.htm I'm not interested in the option combos, but just one option (put or call). Thanks, On Apr 10, 6:36 pm, Tom Jeffries wrote: > Take a look at the attached spreadsheet. I think it does what you want. If > you have any questions let me know. > Tom Jeffries > > > > On Fri, Apr 10, 2009 at 8:44 AM, mother wrote: > > > I'm trying to figure out how to create a Simple Risk Graph (profit/ > > lost diagram) like the one described at Investopedia: > > >http://www.investopedia.com/articles/optioninvestor/05/012605.asp > > > I do not want the add all the extra complexity of stuff. Just a > > simple/basic Risk Graph. > > > Could someone help me with this? > > > If this is not the correct group to post this to, please recommend a > > group. > > > Thanks, > > > > RiskGraph.xls > 23KViewDownload- Hide quoted text - > > - Show quoted text - --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Risk Graphs
I'm trying to figure out how to create a Simple Risk Graph (profit/ lost diagram) like the one described at Investopedia: http://www.investopedia.com/articles/optioninvestor/05/012605.asp I do not want the add all the extra complexity of stuff. Just a simple/basic Risk Graph. Could someone help me with this? If this is not the correct group to post this to, please recommend a group. Thanks, --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
