+ Reply to Thread
Results 1 to 10 of 10

Four quadrant chart

  1. #1
    Registered User
    Join Date
    09-26-2005
    Posts
    39

    Four quadrant chart

    Greetings:

    I'm using Excel 2007 and trying to create a 4 quadrant chart to show how distributors are doing based on two metrics--growth and a calculation we used called PPP. The idea is to have growth on the x axis and PPP on the Y axis. That way, we can spot which distributors have high growth but low PPP as an example. It sounds so easy but I can't figure it out! I drew up a quick sketch to show you what I'd like it to ultimately look like. Any suggestions would be greatly appreciated!

    The sketch is at http://www.chrisfarrugia.com/excel/chart.jpg

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Is creating a 4 quadrant chart impossible in Excel?

    Hi ChrisF79

    You need to plot the values -max(y) and -max(x) then set the colour/color to no-colour
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Registered User
    Join Date
    09-26-2005
    Posts
    39

    Re: Is creating a 4 quadrant chart impossible in Excel?

    Quote Originally Posted by pike View Post
    Hi ChrisF79

    You need to plot the values -max(y) and -max(x) then set the colour/color to no-colour
    Thanks for the reply Pike. I don't really understand what you're referring to though. Could you explain?

  4. #4
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Four quadrant chart

    one attach example workbook is worth a thousand explanations
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    09-26-2005
    Posts
    39

    Re: Four quadrant chart

    Pike, the demonstration is similar to what I need to do but I still can't see how you did it since everything is locked on that sheet.

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Four quadrant chart

    Pike's sheet is protected, but there is no password.

    The attached has 2 series plotted as xy-scatter.
    First series is your data. I used the xy chart labeler addin to link data labels to cells in order to get the Dist information.
    http://www.appspro.com/Utilities/ChartLabeler.htm

    The second series has 2 values plotted at bottom/left and top/right based on data.
    This series can be formatted so it does not appear.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  7. #7
    Registered User
    Join Date
    09-26-2005
    Posts
    39

    Re: Four quadrant chart

    Quote Originally Posted by Andy Pope View Post
    Pike's sheet is protected, but there is no password.

    The attached has 2 series plotted as xy-scatter.
    First series is your data. I used the xy chart labeler addin to link data labels to cells in order to get the Dist information.
    http://www.appspro.com/Utilities/ChartLabeler.htm

    The second series has 2 values plotted at bottom/left and top/right based on data.
    This series can be formatted so it does not appear.
    Andy:

    Thanks so much! That worksheet you attached is absolutely perfect for what we're doing. As far as the labels go, did you manually create those with a text area or are they coming from the data table?

    Also, if we created the national average, say 18% growth and 78 PPP, would it be possible to plot that as a baseline through the other points to see if they fall above or below the national average?

    Thanks again. That's a pretty awesome chart!

  8. #8
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Four quadrant chart

    As I said the data labels are linked to the cells.
    Try selecting the data labels and then select a specific data label. In the formula bar you will see the sheet!cell reference. You can to this manually or use the addin suggested.

    Datum lines can be added to the chart by using extra series. For straight lines you only need the start and finish x,y values.

  9. #9
    Registered User
    Join Date
    09-26-2005
    Posts
    39

    Re: Four quadrant chart

    Quote Originally Posted by Andy Pope View Post
    As I said the data labels are linked to the cells.
    Try selecting the data labels and then select a specific data label. In the formula bar you will see the sheet!cell reference. You can to this manually or use the addin suggested.

    Datum lines can be added to the chart by using extra series. For straight lines you only need the start and finish x,y values.
    Thanks so much for all of your help!

  10. #10
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Four quadrant chart

    Dont forget
    To mark your thread solved do the following:
    - Go to the first post
    - Click edit
    - Click Advance
    - Just below the word "Title:" you will see a dropdown with the word No prefix.
    - Change to Solve
    - Click Save

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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