Results 1 to 5 of 5

How to plot data in a quadrant based on text / values?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-05-2021
    Location
    Netherlands
    MS-Off Ver
    Microsoft Excel 365 (version 2022, Build 14931.20764)
    Posts
    189

    How to plot data in a quadrant based on text / values?

    Dear Excel specialists,

    I have a question.
    Currently I am making an inventory of various applications.
    All applications will be/are divided in 4 catagories (TIME = Tolerate, Invest, Migrate and Eliminate)
    I would like to plot these application names in a quadrant/matrix.

    My question is. How can I achieve this? I assume that I have to assign values to all applications, otherwise I cannot make a "dynamic" overview.
    I also don't want to have overlapping text in the quadrant/matrix, so I tried to assign an additional value to the application names.

    For example:
    Quadrant 1
    1,1 NameA
    1,2 NameB
    1,3 NameC
    and so on
    Quadrant 2
    2,1 NameA
    2,2 NameB
    2,3 NameC
    and so on

    Quadrant 3
    3,1 NameA
    3,2 NameB
    3,3 NameC
    and so on

    Quadrant 4
    4,1 NameA
    4,2 NameB
    4,3 NameC
    and so on


    I downloaded an example that works (please see attached file), based on the information on the left hand side.
    But I don't know how to get this working based on the information that I added on the right hand side (left side can be removed afterwards).
    Maybe it's just changing the scaling, but I am a little lost now.

    Thank you in advance for an answer!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to plot values based on x, y coordinates
    By rgillespie58 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-25-2022, 12:09 PM
  2. [SOLVED] Formula (?) to plot a predicted date based on two values
    By Dabooka in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-03-2014, 09:40 AM
  3. [SOLVED] Quadrant colour based on cell value
    By RoyLittle0 in forum Excel General
    Replies: 14
    Last Post: 05-04-2013, 12:40 PM
  4. XY-plot diagram (text values on x-axis)
    By Lv27 in forum Excel General
    Replies: 2
    Last Post: 12-04-2012, 10:16 AM
  5. Replies: 2
    Last Post: 07-26-2012, 09:27 AM
  6. 4 quadrant graph with text not numerical data
    By Ariana in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-30-2012, 07:25 PM
  7. generating plot based on xstart xstop values
    By frankp in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-26-2007, 02:50 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1