Results 1 to 3 of 3

Thread: Help needed with scatter plot groups

  1. #1

    Help needed with scatter plot groups



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	graph.png 
Views:	35 
Size:	76.2 KB 
ID:	2224  

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,479
    Articles
    0
    Excel Version
    365
    Have a look at the attached workbook
    Click image for larger version. 

Name:	2014-04-14_205145.jpg 
Views:	11 
Size:	45.3 KB 
ID:	2236
    Attached Files Attached Files

  3. #3

    Smile Thank you!

    Quote Originally Posted by p45cal View Post
    Have a look at the attached workbook
    Click image for larger version. 

Name:	2014-04-14_205145.jpg 
Views:	11 
Size:	45.3 KB 
ID:	2236
    Thanks you so much for taking the time to create this workbook, much appreciated!

    Regards
    Melissa

Posting Permissions

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