Results 1 to 2 of 2

Reading values from table to plot on graph

Threaded View

  1. #1
    Registered User
    Join Date
    10-24-2020
    Location
    canada
    MS-Off Ver
    2010
    Posts
    1

    Reading values from table to plot on graph

    Hello guys,

    I am working on an assignment, am trying to display the corresponding number/value on a cell based on a table. To understand this better please see the attached sheet.

    Here is an example of what I am trying to achieve:
    Capture2.JPG

    In the attached Image, you will see there is a graph I am plotting from a table. The number(s) are displayed from the table of the conditions for severity and probability is met. Right now I entered the values manually. If anyone can help me with possible formula or if statements that will display these numbers and also separate each value with a comma or space it will be of great help.

    I have attached the excel sheet as well, please let me know if more information is needed.

    Thanks in advance.
    Attached Images Attached Images
    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. [SOLVED] Can't plot the line graph based on the data in the table
    By Vitalite in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 06-23-2017, 02:34 PM
  2. How to plot no values in a bar graph
    By josephn in forum Excel General
    Replies: 3
    Last Post: 06-03-2014, 04:01 PM
  3. Difficult Graph to Plot, possible need pivot table
    By Jago147 in forum Excel General
    Replies: 1
    Last Post: 02-18-2014, 05:24 PM
  4. [SOLVED] Generate the column of values and plot graph of y=cos(x)-x/2 using VBA
    By jdonprowl in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-30-2013, 02:37 PM
  5. [SOLVED] Want graph not to plot 0 values
    By wolfgang713 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-14-2013, 09:07 AM
  6. Generating Values from a Graph Plot
    By feenix in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 01-18-2007, 02:35 PM
  7. How do I plot non-numeric values in a graph in Excel?
    By Lax in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-30-2005, 12:05 PM

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