+ 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
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,831

    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



+ 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 n_kalpan@yahoo.com 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