Trouble Graphing 1 point w/ 2 variables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top