# Drawing a graph from a large volume of unusual data

1. ## Drawing a graph from a large volume of unusual data

How can i draw a gragh from data that is in the following format

Displacement 0.001
Displacement 0.012
Displacement 0.015
etc
etc
etc  Register To Reply

2. ## Re: Drawing a graph from a large volume of unusual data

You should break column B:B in two columns, by alternate rows, in order
to base a x-y scatter chart on them. Assuming your data start in B1.
Assuming your 2-column breakdown table starts in C2.

In C2:
=OFFSET(\$B\$1, 2*(ROW()-ROW(\$C\$2)), 0)
In D2:
=OFFSET(\$B\$1, 2*(ROW()-ROW(\$C\$2))+1, 0)

HTH
Kostis Vezerides  Register To Reply

3. ## RE: Drawing a graph from a large volume of unusual data

A B C
Displacement 0.001 =B2*1000
Then you can chart it so it is visible

"mems555" wrote:

> How can i draw a gragh from data that is in the following format
>
> Displacement 0.001
> Displacement 0.012
> Displacement 0.015
> etc
> etc
> etc
>  Register To Reply

4. ## RE: Drawing a graph from a large volume of unusual data

Sorting with key = the load-displacement column lets you seprate loads and
displs - you can grab one block and move it next to the other. You may need
to start with an index column with entries = row number. That will always
allow you to recover the original order and correspondence.
Evan Weiner Richland WA

"mems555" wrote:

> How can i draw a gragh from data that is in the following format
>
> Displacement 0.001
> Displacement 0.012
> Displacement 0.015
> etc
> etc
> etc
>  Register To Reply

5. ## RE: Drawing a graph from a large volume of unusual data

Another possibility - use the OFFSET function with a row offset of 2*ROW()-n.
Here n depends on which varible you want and were your data is.

"mems555" wrote:

> How can i draw a gragh from data that is in the following format
>
> Displacement 0.001
> Displacement 0.012
> Displacement 0.015
> etc
> etc
> etc
>  Register To Reply

6. ## Re: Drawing a graph from a large volume of unusual data

I am close to getting it now, but cant quite get it right. Let me show you a
bit clearer what i am trying to do.

Displ1, 0.009
Displ2, 0.006

Displ1, 0.016
Displ2, 0.011
Etc
Etc

How would i need to change the formula you gave me earlier 'vezerid'?  Register To Reply

7. ## Re: Drawing a graph from a large volume of unusual data

So if I understand you correctly you want to plot one indepedent and 2
dependent variables? Then your data will be every 3 rows? If so, adapt
the previous formulae as follows:

In C2:
=OFFSET(\$B\$1, 3*(ROW()-ROW(\$C\$2)), 0)
In D2:
=OFFSET(\$B\$1, 3*(ROW()-ROW(\$C\$2))+1, 0)
In E2:
=OFFSET(\$B\$1, 3*(ROW()-ROW(\$C\$2))+2, 0)

Does this help?
Kostis Vezerides  Register To Reply