+ Reply to Thread
Results 1 to 7 of 7

9 Cells Matrix / GE Matrix chart hellp

  1. #1
    Registered User
    Join Date
    03-18-2014
    Location
    burlington, nj
    MS-Off Ver
    Excel 365
    Posts
    71

    Question 9 Cells Matrix / GE Matrix chart hellp

    I need help with GE Matrix (also called 9-cell Matrix) chart. Bubbles on the chart is outside the range and do not understand what's causing it. I have attached the file. I have played around with it lot but it's not working and very frustrating. Your help is very appreciated.

    Thank you
    Attached Files Attached Files

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

    Re: 9 Cells Matrix / GE Matrix chart hellp

    The center of the bubble is within scale parameters. But the size of the bubble means it extends beyond it.

    Either alter the scale parameters or change the bubble scaling.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    03-18-2014
    Location
    burlington, nj
    MS-Off Ver
    Excel 365
    Posts
    71

    Re: 9 Cells Matrix / GE Matrix chart hellp

    I tried bubble scaling but it's not working. I am not sure what does scale parameters means?

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

    Re: 9 Cells Matrix / GE Matrix chart hellp

    The Min / Max values. You have it fixed as a max of 10. Try 13.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    03-18-2014
    Location
    burlington, nj
    MS-Off Ver
    Excel 365
    Posts
    71

    Re: 9 Cells Matrix / GE Matrix chart hellp

    If i use 13, bubble/circle on chart doesn't reflect the data in the table.

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

    Re: 9 Cells Matrix / GE Matrix chart hellp

    What can I tell you. If you want the bubble within the plot area AND you want to constrain the scale maximum you will need to reduce the size of the bubbles.

    Note the example pic does not have values on the scale but descriptions of the quadrants.

  7. #7
    Registered User
    Join Date
    03-18-2014
    Location
    burlington, nj
    MS-Off Ver
    Excel 365
    Posts
    71

    Re: 9 Cells Matrix / GE Matrix chart hellp

    got it Thanks. I reduced the size and it working fine. thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Matrix Multiplication in VBA and storing values in another matrix
    By anwid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-06-2018, 06:23 AM
  2. [SOLVED] VBA to convert a coloured matrix into an equivalent matrix of 1's and 0's
    By The_Snook in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-27-2017, 01:12 PM
  3. Finding a specific row of a matrix in another matrix
    By hfarhadi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-27-2014, 04:14 PM
  4. Replies: 2
    Last Post: 11-05-2014, 03:41 AM
  5. Eigenvector of matrix for nxn matrix of variable size
    By rocketscientist165 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-14-2014, 10:51 AM
  6. Replies: 2
    Last Post: 02-11-2014, 05:05 AM
  7. Using a transition matrix as input to a cummulative matrix
    By Walter12 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2012, 04:19 AM

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