# How to plot 3 variables in scatter plot with excel formula

1. ## 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

2. ## 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

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

#### 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