| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use variables in Excel? | Excel Discussion (Misc queries) | |||
| How do I use variables in Excel? | New Users to Excel | |||
| plotting 2 variables as scatter and naming each point | Charts and Charting in Excel | |||
| Graphing Trouble | Excel Discussion (Misc queries) | |||
| decimal point override does not work | Excel Discussion (Misc queries) | |||
Linear Mode
