need help from the excel gurus...

Reply #9

time*treat — Sat, 28 Jan 2006 03:14:10 GMT

If all else fails, hyper's secured a solid future career as a map maker

Reply #8

hypersoniq — Sat, 28 Jan 2006 01:17:02 GMT

sort of..I have a grid for numbersit spans 55 columns 1-55 in the cells from left to rightas it stands now, I can enter a powerball drawing into a set of cells, and on the grid... white balls are indicated by yellow highlighting, powerball is indicated in red highlighting, and the coincident match (powerball is same as a white ball) turns the cell inthe grid black w/ white text.this is basically an entirely automatic way to produce the late kbcherokee's excel bell curve . (he did it by han... [ More ]

Reply #7

lottaloot — Thu, 26 Jan 2006 04:05:15 GMT

I'm getting as bad as Lotta... gotta write them routines no matter what. Who me

Reply #6

cahaba — Thu, 26 Jan 2006 02:48:09 GMT

sonic-Are you after a graph

Reply #5

hypersoniq — Tue, 24 Jan 2006 10:46:51 GMT

thanks!i had gotten as far as ActiveSheet.Shapes.AddConnector(msoConnectorStraight, X1, Y1, X2, Y2).Selectbut ActiveSheet.Shapes.AddLine(X1, Y1, X2, Y2).Selectseems much simpler.

Reply #4

time*treat — Tue, 24 Jan 2006 05:29:02 GMT

for hyper...Sub line_maker() Dim std__col, std__row Dim base__row As Double Dim in__row As Double, out__row As Double Dim in__col As Double, out__col As Double Dim in__val As Double, out__val As Double 'cell width = 8.43 'cell height =10.5 'first 11 rows' std__col = 48.75 std__row = 10.5 ActiveSheet.Lines.Delete 'deletes all lines' For base__row = 1 To 10 in__val = Cells(base__row, 1).Value out__val = Cells(base__row + 1, 1).Value in__col = std... [ More ]

Reply #3

hypersoniq — Mon, 23 Jan 2006 23:03:27 GMT

thanks for the tip... macro/vba would be fine... I'll try that

Reply #2

time*treat — Mon, 23 Jan 2006 16:09:23 GMT

I wound up with 0 in B1 and 10 in L1. As far as the arrows ~ the way they're drawn from VBA, it looks like you will have to determine/set the width of the cells as part of your calculation. I won't say it can't be done as part of a regular spreadsheet formula, but I did a record macro , and toyed with the values there, then reran.

Reply #1

lottaloot — Mon, 23 Jan 2006 03:23:16 GMT

Over my head....Way over

need help from the excel gurus...

hypersoniq — Sun, 22 Jan 2006 19:58:46 GMT

I am trying to find some way of getting a line to draw on a worksheet connecting numbers in a range based on the results of a cellfor example,cell A1 contains 5... cells B1-L1 contain 0-9Cell A2 contains 8... Cells B2-L2 contain 0-9I want to insert a line that has one endpoint centered in the cell G1 and the other endpoint in the cell J2I would like to automate chief's bell curve concept by adding lines