Trouble Graphing 1 point w/ 2 variables
How can I graph something as 1 point when it has two variables? I am trying
to graph several different asset classes by their risk and reward variables. I want risk on my x axis and return on my y axis. When I tryin using xy scatter chart, I get two points. What am I doing wrong? |
In step 2 of the chart wizard, make sure XL creates 1 series with the
first value as the x-value and the 2nd as the y value. If XL shows 2 series, copy the range assignments to the appropriate x/y fields and delete the 2nd series. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... How can I graph something as 1 point when it has two variables? I am trying to graph several different asset classes by their risk and reward variables. I want risk on my x axis and return on my y axis. When I tryin using xy scatter chart, I get two points. What am I doing wrong? |
Trouble Graphing 1 point w/ 2 variables
Hi Tushar - I'm not understanding your answer - are you referring to an xy
scatter chart? Can you please clarify. Thanks very much! "Tushar Mehta" wrote: In step 2 of the chart wizard, make sure XL creates 1 series with the first value as the x-value and the 2nd as the y value. If XL shows 2 series, copy the range assignments to the appropriate x/y fields and delete the 2nd series. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... How can I graph something as 1 point when it has two variables? I am trying to graph several different asset classes by their risk and reward variables. I want risk on my x axis and return on my y axis. When I tryin using xy scatter chart, I get two points. What am I doing wrong? |
All times are GMT +1. The time now is 12:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com