Excel help

[Vipers]

Been a long time since I used a spreadsheet, forgot how to draw a line from bottom left of a cell to the top right top cell a few lines above it.

Think I have to open something or another, but cant remember what.

[Chozza]

What are you trying to get the line to do ?

If just a line > insert > shapes > pick a connector at the top

or something else

[Vipers]

Chozza said:

What are you trying to get the line to do ?

If just a line > insert > shapes > pick a connector at the top

or something else

I have a number of cells, its to do with a decompression sheet, and want to show the ascent rate, so need to draw a line from left hand corner of a cell, up to the top right of another cell a few lines above it, done it years ago, think I need to have something at the bottom of the spreadsheet showing stuff like text box etc.

ie line from bottom left hand of cell a35 to top right of b30

[Vipers]

Chozza said:

What are you trying to get the line to do ?

If just a line > insert > shapes > pick a connector at the top

or something else

Got it, thanks.

[sideways sid]

Vipers said:

I have a number of cells, its to do with a decompression sheet, and want to show the ascent rate, so need to draw a line from left hand corner of a cell, up to the top right of another cell a few lines above it, done it years ago, think I need to have something at the bottom of the spreadsheet showing stuff like text box etc.

ie line from bottom left hand of cell a35 to top right of b30

One day perhaps someone will invent a programme that will draw a line to show the rate of decompression automatically, based on the numbers in your spreadsheet!

[mmm-five]

sideways sid said:

One day perhaps someone will invent a programme that will draw a line to show the rate of decompression automatically, based on the numbers in your spreadsheet!

Maybe call it something like 'chartograph' or 'trendiline'?

[Vipers]

sideways sid said:

Vipers said:

I have a number of cells, its to do with a decompression sheet, and want to show the ascent rate, so need to draw a line from left hand corner of a cell, up to the top right of another cell a few lines above it, done it years ago, think I need to have something at the bottom of the spreadsheet showing stuff like text box etc.

ie line from bottom left hand of cell a35 to top right of b30

One day perhaps someone will invent a programme that will draw a line to show the rate of decompression automatically, based on the numbers in your spreadsheet!

Already have an excell spreadsheet which shows all we need to know about decompression covering about 6 or 7 different tables, just a basic exell worksheet, enter the data, and it prints out the entire decompression sheet, I was trying to draw the outline of a shallow table, showing the depths, and ascent to the next level, but thanks for the idea.

Thanks again guys, can always rely on someone knowing something on PH,s