+ Reply to Thread
Results 1 to 3 of 3

Creating a quality vs Production graph

  1. #1
    Registered User
    Join Date
    06-12-2008
    Posts
    2

    Creating a quality vs Production graph

    Hi there,

    I'm glad i stumbled across this forum as I haven't been able to figure something out. I'm very new to excel, by which I mean i just started using it for the first time 3 days ago, but that hasn't stopped my work from giving me tons of things to do with the program. Anyways, i'm learning quickly but i;'m having difficulty figuring out how to make a graph which shows a workers production on the y axis and the quality on the x axis. However, instead of having two points on a standard xy scatter graph, I need a four quadrant graph that plots the worker (as a single marker on the graph) in one of the quadrants.

    Basically i want any worker in the
    upper right quadrant: to have high production and quality,
    lower right quadrant: to have low production but high quality
    lower left quadrant: to have both low production and quality
    upper left quadrant: to have high production but low quality.


    If anyone can shed some light on this you will make my workday much better.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,453
    What data do you have?

    XY-scatter is probably the chart type you want. It's a case of understanding your data.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    06-12-2008
    Posts
    2
    Thanks for taking a look but i believe i figured it out. I simplified it to overall quality and overall production for my two data types, then the assessors name. I used the xy scatter and just inserted a gridline on both the x and y to sort the quadrants. I'm assuming my boss will be ok with this, the only thing i could see him wanting changed is when i put the gridlines in i had to change the values for it to only show up in the middle of my graph, and as a result It's no longer showing me the numbers on my x and y axis between the two gridlines. This however is of minor concern so if it;s stuck like that then that's fine.

    Thanks again for the speedy reply.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1