Scatter chart for two data sets

[junebug]

I have column A filled with 300 names. Column B has the persons quality score %. Column C has that persons AHT time. I am trying to create a scatter chart that will display the distribution of people into four quads. The people with high quality and low AHT etc. Can anyone help me. Maybe I am not explaining it well.

Thanks

 

[dave3009]

You mean similar to a Boston Matrix?

 

[junebug]

I am not familiar with a Boston Matrix but that could be it. Can you explain how I would do that?

 

[dave3009]

OK

Instead of just selecting a range and forming a graph from it you do Series

Click the Chart Icon

Choose XY Scatter

Click Next

Choose the Series Tab click Add

Reference Name to persons name
Reference X axis to Quality score percentage
Reference Y axis to ANT Time

You'll need to repeat this process for each point. As you have 300 records to plot I am hoping someone might be able to adjust this code to help

Sub UpdateBMChart()
    ActiveChart.PlotArea.Select
    ActiveChart.SeriesCollection.NewSeries
    ActiveChart.SeriesCollection(2).XValues = "=Sheet1!R2C2"
    ActiveChart.SeriesCollection(2).Values = "=Sheet1!R2C3"
    ActiveChart.SeriesCollection(2).Name = "=Sheet1!R2C1"
End Sub

HTH


Dave

 

[Jon Peltier]

You're going to die at 255 series, and the user didn't request custom labels. Cutsom labels are much easier using one of these great utilities:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

I presume you want something like this as your four-quad chart:

http://peltiertech.com/Excel/Charts/ColoredQuadrantBackground.html

 

[dave3009]

I'm glad an expert responded, Cheers Jon

 

[junebug]

Thank you for all the great ideas and links. You guys are the best.