points

I created a clustered column graph in excel plotting 2 different data points. When I print the graph, there is a "box" around the 2 bars. It's only noticeable on the ones where there is a difference between the 2 data points. The "box" cannot be seen when both data points are the same. The...

Looking for a formula to calculate a pool player’s averages in a pool league…. Players play a 9-ball match, set of games. Each pocketed ball (1 thru 8) is worth 1 point, with the 9 ball being worth 2 points. Players have a skill level (S/L) ranging from 0 thru 10, in .25 increments. [6.00...

Hello, I am currently trying to develop an attendance tracker in Excel that will minus 1 point if 30 days of perfect attendance is achieved. I have been able to write a formula that will deduct the points if that time frame is met but, the problem is that when they get another point for absence...

I use Excel some but not much with the macros. I did some searching but haven't found exactly the combination I need. I'm keeping track of basketball stats during a game and in column A I have the players. I want to be able to select the player then click on a button when they score 1 point...

I currently have a trend line with the following trend line equation, y=-0.0131x+580.53. I am trying to determine the start and end points of the trend line. I have 19 data points please let me know if sharing the data points would be helpful or are they relevant considering I am addressing the...

Hi All I have the below raw data and i want to create a Stacked column chart in excel 2010. I have created the chart but only concern is the values of Data points is not aligning to Y axis bar. Can anybody tell me how to attach the excel file which i did so that it will be helpful to you to...

Hi all, Hoping someone can help me with this scatter plot question. I am trying to connect 3 data points with a line to help show a pattern of play in a tennis match. I am able to plot each data point however I would like to connect them together for each play. The data I have looks like...

Hi, I hv some amount like 25000. and I want to divide it on 9 employee. It show result in point like 2777.78 I want result without points. Like if I give 2778 to 7 person and 2777 to other 2 person. with this I can easily divide amount on all 9 employee. if there is any formula which I can...

I am creating a workbook for six managers. Every time a manager passes a training course, they receive 2 points. Supposed John Smith has 4 points in cell B3 and he passes another training course, I need to add a 2 to his existing total, giving him 6. Also, if he missed a course, we subtract 1...

I have a graph with a trend line and am wondering how can I determine what the start and end points of the trend line are?

I have a fictive criminal register and would like to count number of points on the driver's license. I have a COUNTIFS that looks up the social security number from H3. D has the social security number and V has "1 point", "2 points" or "Suspension" (3 points yields suspension). Here I have...

hello, I'm using the "&A1&" formula to reference dollar value totals. Cell A1 is formatted to 2 decimal points, but the referenced cell destination is adding more than 2 decimal places! thanks

Because the heading is so clear! I have the following data: <tbody> A B C D E F H I J K UPN Name Year SEN Care FSM Subject Type Class Points 123 abc 7 S Y Y Geography Homework 7L4/Gg 1 456 def 7 Technology Homework 7L4/Te 1 678 ghi 8 S Y Science Disruption to Learning 8a/Sc3 2...

Hello everyone! I've recently got a task to do in excel: "There are points A(-1,0) and B(3,0). Find point C, for which the ACB angle is a right angle." There was also something mentioned about the method of searching an axis??? I understand this and I know how do do it on paper but have...

is there a formula for this, or even some VBA ? Column A has a list of times, shown mm:ss, I want to 'award' points in relation to the times being closest to zero. The points awarded would start with the time closest to zero being either a + OR - time. The points start at the total number of...

I am trying to do a scorecard based on number of drinks consumed per week. Drinks consumed are entered daily the Week Total would keep a running point total. As drinks are consumed the total points would decrease. I was using a vlookup with a sum shown below...

I'm trying to write a multiple if(or statement with three data points. IF(OR(AA11046="AAA",OR(AA11046="AAB",OR(AC11046="YES"))),"YES","NO") Brings back "no" no matter what. I'm trying to say if the points are aaa and aab and yes then give me yes. all others should be no. Any help is...

My wife runs a fitness group which hosts team competitions. The team individuals get points each day for doing things they are supposed to do. They receive negative points for doing things they should NOT do. The values from each day of the week for the bad things are totaled to determine...

Hello, I'm trying to simplify the addition of thousands of hyperlinks in a spreadsheet. I have the pictures in a folder and just need to figure out how to get autofill to work with the addressing. The formula below points to the beginning of a series of pictures. How can I drag down and...

I think I came across a cool workaround for gluing connectionlines to the corners of a rectangle. The normal connection points are in thecenter of each side. I wanted connection points at the corners. Using Insert Shape, I drew a large rectangle whilezoomed out to ~10%. I then zoomed into the...