Results 1 to 9 of 9
  1. #1
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Graph Question (2000 SR1)

    I have been asked to help plot the following data set.

    Month, CPI, SPI.

    Easy enough. However, here is some data.

    April 04, .986, .997
    May 04, .993, .957
    June 04, .995, 1.016

    Basically, the graph is similar to a bulls eye chart where the X axis is the SPI, Y axis is the CPI, and time is a third dimension not shown. The CPI and SPI combined make the data series for the graph.

    To plot this, for April 04, the data point would is marked by going .997 on the X axis and then up .986 on the Y axis and drawing the data point. (The data point is at .997, .986). I can't seem to get this to work, any suggestions. I do not want to see two data points for any one month but the intersection of the data points.
    Regards,

    Gary
    (It's been a while!)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Graph Question (2000 SR1)

    Sinct you want to use CPI and SPI as values for the x-axis and y-axis, it is easiest if you select only those to create the chart, not the Month column. Select XY (Scatter) as chart type. You can use Rob Bovey's XY Chart Labeler to add the months as data labels. See attached.

  3. #3
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Graph Question (2000 SR1)

    Hans,

    Thanks for the quick response. I already went this route and only used the the data (excluding the month) to create the Scatter Chart but still got two data points. I even tried setting the data points as (x,y). Can you get it to plot one data point based on the intersection of the data series?
    Regards,

    Gary
    (It's been a while!)

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Graph Question (2000 SR1)

    This is what I used to create the chart in the workbook I attached to my previous reply:
    - Select B2:C4.
    - Click the Chart Wizard button on the toolbar.
    - Select XY (Scatter).
    - Cick Next.
    - The chart already looks OK then - three data points at the correct positions.
    - There is only one series, with X values =Sheet1!$B$2:$B$4 and Y values =Sheet1!$C$2:$C$4.
    - Click Next.
    - Turn off the legend in the Legend tab.
    - Click Next.
    - Click Finish.

    I then selected the single series and formatted the markers, and used the XY Chart Labeler to use Sheet1!$A$2:$A$4 as data labels.

    Is this not what you want? If so, please explain.

  5. #5
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Graph Question (2000 SR1)

    Hans,

    Yes, that is what I want. Sorry for the confusion.

    Now, to make it really slick, is there a way to automatically draw an arrow for the data points from April to May and then May to June, etc.?
    Regards,

    Gary
    (It's been a while!)

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Graph Question (2000 SR1)

    A line between the data points is easy: just change the chart subtype or format the data series. An arrow is something else - the arrows would have to be drawing objects. I have never had much luck with the precise placement of drawing objects on a chart, if you get them just right on-screen, they print slightly differently.

  7. #7
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Graph Question (2000 SR1)

    Hans,

    I figured the arrows would be a challenge. Do you know of any links I can review where they have an example of automatically inserting objects into a graph. The users want to show the arrows from point to point but I think I may have to tell them it will take too much time to figure out.

    Thanks for your help.
    Regards,

    Gary
    (It's been a while!)

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Graph Question (2000 SR1)

    If your points don't change much, it would not be that difficult to draw them with the arrow button on the drawiing toolbar.

    Steve

  9. #9
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Graph Question (2000 SR1)

    Steve,

    Thanks for the response. Manually drawing them is not an option as this will eventually be an automated process.
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

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