multiple data points with identical coordinates in scatterplots

kimbo

New Member
Joined
Apr 10, 2002
Messages
38
I am doing some simple 2-D scatterplots in Excel. For example, "grade in course" by "total number of questions correct on final exam."

Is there a way to show multiple data points with identical coordinates in these 2-D scatterplots? For example, if two people both got 26 questions correct on the final exam and a course grade of B-plus (3.33), then only one data point would show.

By convention, data points with identical coordinates often are shown by clustering them.
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
By definition, you CANNOT show two identical sets of coordinates on a graph. The only way is to change one of the coordinates, say the y-values, slightly.
 

kimbo

New Member
Joined
Apr 10, 2002
Messages
38
Thanks, RalphA. Good idea (to change the coordinates slightly). Best, -- Kimbo
 

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
Yes, kimbo, but change only one. I prefer to change only the x-values, say by adding as small an increment as possible, as long as I can see the diferent poins clearly enough.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,626
Messages
5,469,785
Members
406,670
Latest member
Jimborusk13

This Week's Hot Topics

Top