Help needed with scatter plot groups

Mel

New member
Joined
Apr 10, 2014
Messages
2
Reaction score
0
Points
0
Hi

I'm an Excel novice and have been asked to help create a graph like the one in the attached image. I've done online searches and it seems this is a scatter plot graph with groups. However, the x axis needs to have categories and not numbers, and it seems the x axis on a scatter graph has to be numbers. Is it possible to use Excel to create a graph that will look like the attached image?

Thank you in advance for any help
Melissa
 

Attachments

  • graph.png
    graph.png
    76.2 KB · Views: 42

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,168
Reaction score
10
Points
38
Excel Version(s)
365
Have a look at the attached workbook
2014-04-14_205145.jpg
 

Attachments

  • ExcelGuru2916ScatterPlotWithGroups.xlsx
    20.6 KB · Views: 16
Top