+ Reply to Thread
Results 1 to 2 of 2

Trouble Graphing 1 point w/ 2 variables

  1. #1
    Will
    Guest

    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. #2
    Tushar Mehta
    Guest

    Re: Trouble Graphing 1 point w/ 2 variables

    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 <[email protected]>,
    [email protected] 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1