+ Reply to Thread
Results 1 to 2 of 2

How to plot 3 variables in scatter plot with excel formula

  1. #1
    Registered User
    Join Date
    06-30-2009
    Location
    Dhaka,Bangladesh
    MS-Off Ver
    Excel 2003
    Posts
    7

    How to plot 3 variables in scatter plot with excel formula

    Hi i need to plot 3 variables(A,B,C) in scatter plot graph where A will be in Y axis,B will be in X axis & 3rd variable(C) will be visualized on (X,Y) point as several colors based on each value of C. Formula is also needed.

    A B C

    1066 25.9% 7 X=1066,Y=25.9%.this (1066,25.9%) point will be colored based on C=7
    1193 23.2% 3 X=1193,Y=23.2%.this (1193,23.2%) point will be colored based on C=3
    1436 14.5% 3 and other in below like above
    1662 13.0% 2
    1417 49.9% 8
    1257 40.9% 3
    1030 28.7% 1
    1297 26.2% 8
    1276 20.5% 4
    1670 9.9% 1
    1641 13.0% 3
    1293 20.6% 3
    2213 17.8% 1
    2243 3.9% 8
    1129 18.8% 2
    1323 17.8% 4
    1943 50.6% 11
    1982 7.0% 1
    1152 26.1% 1
    1354 43.8% 11
    865 19.2% 6
    872 27.9% 3
    1052 28.1% 2
    902 20.2% 10
    1695 17.2% 2
    528 28.3% 10
    1380 30.7% 4
    1040 26.3% 6
    1188 15.5% 5
    833 23.5% 8
    1138 19.7% 2
    1471 16.3% 2
    1255 14.8% 4
    1227 15.9% 3
    1283 45.4% 12
    1494 41.7% 14
    902 17.2% 11
    1556 7.1% 4
    1548 15.3% 3
    975 44.4% 6
    1173 29.4% 8
    1443 40.6% 11
    1346 11.1% 5
    1932 7.2% 6
    1132 22.0% 2
    2296 7.2% 1
    1913 30.8% 12
    1664 18.8% 5
    1543 17.7% 3
    1970 24.3% 9
    1670 15.9% 1
    772 27.0% 5
    Last edited by tanvir; 03-13-2017 at 01:04 AM. Reason: i am using Excel 2010

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: How to plot 3 variables in scatter plot with excel formula

    Here are two approaches that you might be able to adapt for your own needs:

    http://stackoverflow.com/questions/1...o-column-value
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ 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. Scatter plot with 3 variables
    By crystalcastle in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-09-2016, 02:10 PM
  2. Scatter Plot Diagram with 3 Variables
    By [email protected] in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-21-2015, 12:35 PM
  3. Converting Scatter plot to Line plot and back
    By SPDavern in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-26-2015, 10:49 AM
  4. Excel 2010 - X Y scatter plot will not plot empty cells as gap
    By bjeffers0306 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-12-2013, 12:56 AM
  5. Replies: 2
    Last Post: 07-26-2012, 09:27 AM
  6. Can I copy x-y scatter plot data direct from one plot to another?
    By Chris in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-03-2005, 09:05 AM
  7. Converting XY Scatter plot to Line Plot and back
    By SPDavern in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-09-2005, 10:06 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