+ Reply to Thread
Results 1 to 1 of 1

Assign marker according to data from table

  1. #1
    Registered User
    Join Date
    06-26-2019
    Location
    Malaysia
    MS-Off Ver
    Office 2016
    Posts
    1

    Assign marker according to data from table

    Hi everyone,

    I would like to seek your opinion on the issue i'm currently facing.
    i have a set of data and have plotted them in a simple scatter plot.
    excel.PNG

    However, i would like the the plot to also include the "Gender" data as input and shown as a different marker in the plot like figure below.
    excel2.PNG

    I know that i can do it manually (by editing the marker one by one), however i'm wondering if there is another way to do it automatically?

    I appreciate any help. Thank you.
    Attached Images Attached Images

+ 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. Assign numeric code to a table with data
    By slysud in forum Excel General
    Replies: 3
    Last Post: 02-15-2016, 10:21 AM
  2. If Vlookup N/A, Input Box to Assign the look up cell to the data table
    By francisExcelWizard in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2015, 05:49 PM
  3. If Vlookup N/A, Input Box to Assign the look up cell to the data table
    By francisExcelWizard in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2015, 02:56 PM
  4. We need to generate an auto assign ranking place using data from a table.
    By fbarrio73 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-02-2015, 11:22 PM
  5. Excel 2007 : Format Data Series (Marker Option)
    By nilz23 in forum Excel General
    Replies: 3
    Last Post: 02-15-2011, 04:25 AM
  6. [SOLVED] Data Marker
    By km2412 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-05-2006, 10:55 PM
  7. How do I plot two columns of data as one data point/marker in a ch
    By Tim L Cole Haan in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-30-2005, 09:00 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