How to do a diagram

I want to do a diagram where my values is in A2, B2, C2, A3, B3, C3... How do I do?

Draw your shape (e.g. A rectangle)

Click on your shape and in the formula bar enter your formula. (e.g. =A2)


BP

I think we had an misunderstanding. Let me give you an exampel:

I have a microsoft excel 2003 sheet where it says:

A B C
1 1 2 3
2 4 5 6
3 7 8 9


I want do do a diagram with a straight line of the values in cell ( in the exact order ) : A1, B1, C1, A2, B2, C2, A3, B3, C3

How?

Does anybody understand me?

Originally Posted by Gos-C

Hi bob_hund,

Do you mean a chart/graph?

Gos-C

Yes! Yes.
sorry. I'm from Sweden.

Originally Posted by shg

You could use a formula to put the values in a single row, and then make a line graph of the result:

Please Login or Register  to view this content.

The formula in A6 and down is

=INDEX($A$1:$C$3, INT((COLUMN() - 1) / 3) + 1, MOD(COLUMN() - 1, 3) + 1)

I can't get it to work becouse I have a swedish excel. I'm gonna try it out at my home computer tonight when I'll get home from work.

Thanks for the help. It worked.

Now I only have one problem left.
If the cell is empty it returns 0. I want it to stay empty... How do I do it?

Thank you verry much.

I found an easier way. Replace every empty cell with an "t"...