Excel Help

[montage]

First step, If I had the coordinates for a square's (x,y for each corner), then how would I plot that square onto excel?

Secondly, how would I then plot many others onto that same graph? - about 40 in total.

I can also work with MatLab if that is the only way - but I am pretty illiterate.

Help would be hugely appreciated, this is for my dissertation which has a looming deadline, and playing with excel is using up a lot of valuable time!

Just to let you know what you are helping me a achieve, I'm trying to determine how a groyne impacts sediment on the beach, so this graph would be plotting movement.

Many thanks!

 

[montage]

Perhaps this should have gone in the computers and electronics forum...apologies!

 

[vernon]

I'm trying to determine how a groyne impacts sediment on the beach, so this graph would be plotting movement.
Many thanks!

The sediment normally impacts on my groin on the beach. Any movement is entirely due to displacement activities in the groin to reduce the discomfort.

 

[Andy_R]

and it gets in your sarnies


(edit: the sand gets in your sarnies, not Vernons groin.......I hope)

 

[montage]

The sediment normally impacts on my groin on the beach. Any movement is entirely due to displacement activities in the groin to reduce the discomfort.

I call bollocks

 

[annedonnelly]

First step, If I had the coordinates for a square's (x,y for each corner), then how would I plot that square onto excel?

Secondly, how would I then plot many others onto that same graph? - about 40 in total.

I can also work with MatLab if that is the only way - but I am pretty illiterate.

Help would be hugely appreciated, this is for my dissertation which has a looming deadline, and playing with excel is using up a lot of valuable time!

Just to let you know what you are helping me a achieve, I'm trying to determine how a groyne impacts sediment on the beach, so this graph would be plotting movement.

Many thanks!

Put your x co-ordinates in one column and your y co-ords in the next, select the two columns and then use the graph wizard to create a scatter graph. I think that should do what you want.

 

[montage]

Put your x co-ordinates in one column and your y co-ords in the next, select the two columns and then use the graph wizard to create a scatter graph. I think that should do what you want.

More or less.... but need to join the points to make the square. Might resort to just drawing the line in on a scatter plot as you say

 

[annedonnelly]

Ah, I misunderstood. Can you change the point marker to be a square the size you want and then simply plot the centre of each square?

 

[montage]

Ah, I misunderstood. Can you change the point marker to be a square the size you want and then simply plot the centre of each square?

It is an option, I think scatter graph and manually drawing using the insert objects tool is by far the most simple way to achieve the aim, not perfect but oh well, we'll see

 

[Markymark]

http://www.mrexcel.com/forum/excel-questions/398063-drawing-line-visual-basic-applications.html

http://www.automateexcel.com/2004/08/19/excel_programmatically_draw_boxes_with_c/

If you are happy to use macros then the above should work.

Vba (macros) takes some getting used to if you're not into code but it means you can do so much more in excel.