Drop line graphic

[nobbyknownowt]

Just wondering if excel can cope with this?
I'd sooner continue my project in excel than learn another program i
possible!

I need to produce a graphical representaion of the attached jpg
Perhaps a chart?? (sorry for my leaky pen but hopefully you'll get th
idea!)

Let me explain.
the start point is a variable on a scale 0-100 which the sheet knows
say A B or C A=30 B=45 C=36

The subsequent lines change the start point number
ie (using the letters down the right hand side)
E = +8
D = +6
C = +2
B = -11
A = -6

The chart needs the slanting lines (repesenting 200,500 etc) or som
other indication so that a manual check can be made of the compute
caluculation. (The 200,500 lines can be calculated as numbers on th
same 0-100 scale)

The sheet has elsewhere calculated these numbers and produced a result
Its the graphical representation of whats going on that I'm after.

Can it cope, and does anyone have any pointers????
cheers
Nobb

+-------------------------------------------------------------------
|Filename: drop line.JPG
|Download: http://www.excelbanter.com/attachment.php?attachmentid=82
+-------------------------------------------------------------------

 

[Jon Peltier]

Could you give a little information about what the chart is trying to
represent?

- Jon

 

[nobbyknownowt]

Hi Jon
The chart is the representation of a shift in center of gravity as a
aircraft is loaded.
The letters down the left indicate a particular area, each area wil
have a different effect on the index at the top depending on the weigh
and distance rfom the fulcrum.

Now excel can calculate all this for me and produce the necessar
answers.

What I would like to do it put a chart (stacked line xy or something
so that a manual check of what is going on can be done where there i
no computer access (ie on an aircraft).

In the jpg. the line starts at the top, moves vertically down until i
intersects a slanted line it then moves horizontally (left or righ
dependant on the arrow at the left) a corresponding amount. (I woul
think that the x index +/-change would be used for this) Then the lin
drops down vertically again tio the next section.

So the slanted lines represent say a 200kg weight in the area and i
there was 400kg in the area the line would drop into the section fro
above move across 2 slanted lines before dropping to the lext area.

All the actual numbers required for the chart have already bee
calculated by the spreadsheet, its just how to transfer them over an
formt the chart.

heres hoping
cheers
Nobb

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[nobbyknownowt]

Ha ha ha ha ha ha ha haaaarrrrrrrrr!!!!!
!!


Have done it somewhat longhand mind!

Have made every single diagonal line a data series x coords inde
difference and y coords even numbers 0 - 14
and then run the drop line through the lot x coords on the index chang
and y coords odd numbers 1-13.

Works a treat and looks just like the jpeg but makes for a long
tedious job. Too big a file to attach to post

off to rest me tired fingers!!!



nobb

+-------------------------------------------------------------------
+-------------------------------------------------------------------