+ Reply to Thread
Results 1 to 6 of 6

Matrix

  1. 12-12-2018, 04:34 AM #1
    kierra_kk
    kierra_kk is offline
    Registered User
    Join Date
    08-16-2017
    Location
    Germany
    MS-Off Ver
    15.31
    Posts
    35

    Matrix

    Hi Everyone,

    I am trying to create a Matrix chart:

    the excel sheet looks like this:

    EW Im RF

    1 5 5
    2 3 6
    3 2 6
    1 2 2
    3 5 15
    4 4 16
    5 5 25
    5 5 25
    . . .
    . . .
    . . .

    Attached is the chart I want to represent.
    So IM and EW are "XY" and RF is the values presented in Graph.

    so for example value "25" in RF is 2 times so I should see these two points in the ghraph
    The maximum value of X and Y is 5 and max value of RF is 25.

    The dots should also be colorful for example 1-5 is green, 6-10 is dark green, 11-15-yellow. 16-20 -Orange and 21-25 is red
    I have applied color formatting in excelö sheet for these values, but would be nice to see these colors in the graph as well.

    Please let me know if something is not clear.

    I want to show in graph these color zones- green zone, orange zone and red zone.

    Thanks in advance for the help and time!

    Kierrra
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 12-12-2018, 04:59 AM #2
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,616

    Re: Matrix

    two identical points (RF is 25 for 5 and 5 EW and Im) - it's not a standard issue. Is duplicate the toughest case or can you have also triplets or more?

    As for "conditional formatting of " 1-5 is green, 6-10 is dark green, etc" it's a bit easier, but I do not think the screenshot you postet shows this well enough.
    Best Regards,

    Kaper
    Reply With QuoteRegister To Reply
  3. 12-12-2018, 06:04 AM #3
    kierra_kk
    kierra_kk is offline
    Registered User
    Join Date
    08-16-2017
    Location
    Germany
    MS-Off Ver
    15.31
    Posts
    35

    Re: Matrix

    No duplicate is not the toughest case, it could be a lot of them. So it will be nice on the graph if I could see the dots with numbers. For e.g. 10 values were 25
    The screenshot of graph is not correct. That is what the problem is. Its neither working with colors nor with values.

    I am attaching the excel sheet for better understanding.
    I tried to sketch in manually what I want as Output. May be with thsi sketch you get an idea what is in my mind

    Please let me know it is not clear

    Thanks!
    Attached Files Attached Files
    Last edited by kierra_kk; 12-12-2018 at 08:20 AM.
    Reply With QuoteRegister To Reply
  4. 12-12-2018, 12:22 PM #4
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,616

    Re: Matrix

    I've got no foggiest idea how your bubbles and numbers in them (sketch in range E22:H33) are related to data in A2:C18

    From the original description, I expected a picure rather like on a screenshot (probably with added colors following value of RF), but as I do not know what you really expect, I'm waiting for clarification.
    Attached Images Attached Images
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 12-12-2018, 12:45 PM #5
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,719

    Re: Matrix

    Please note for future reference that we expect your thread titles to be a little more detailed - one word is not enough to hint at the issues you are facing.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  6. 12-12-2018, 01:32 PM #6
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,616

    Re: Matrix

    PS. The numbers in circles are counts of repetition
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] 9 Cells Matrix / GE Matrix chart hellp
    By vani2004 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-20-2018, 02:34 PM
  2. 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
  3. [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
  4. How to make a symmetric matrix from asymmetric matrix by averaging two values
    By latte in forum Excel Formulas & Functions
    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. Macro to make a (N X N) Matrix to (N-k) X (N-k) matrix by hiding remaining columns & rows
    By Pellissery in forum Excel Programming / VBA / Macros
    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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1