# Thread: Graph Question (2000 SR1)

1. ## 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.

2. ## 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. ## 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?

4. ## 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. ## 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.?

6. ## 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. ## 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.

8. ## 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. ## 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.

#### Posting Permissions

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