Quadrant Scatter Graph

[Jmarsh4]

Hello! I've been through everything I can findand can't figure out how to create this. I have approximately 200 employees with two data points, response time and sales dollar amount, that i need to represent in a scatter chart. The scatter chart needs to include one "dot" for each employee rather than two - thought i did this with a series, but then the employee name doesn't show when you hover over the "dot", which my boss needs. Also need to show quadrant lines based on values i define (ie, response under 21% and sales over $8), not intersect at 0. However, need quadrant lines to be within chart, not move the existing axis. I've attached an example. I would greatly appreciate any help.

[Andy Pope]

No attachment?

In order to have each point with a valid chart tip you will need to create a series for each data point. Getting the chart to do this automatically from just selecting the data is a problem. Using code is simpler.

Assuming data is in columns A:C with Name in column A and x and y values in B:C. The following will create a chart.

Please Login or Register  to view this content.

The quadrent divider lines can be made using another data series to draw the lines

[Jmarsh4]

That's perfect; the information around identifying each user as an individual series is exactly what I needed, and I figured out the quadrant lines!