Index Chart

[jpgordo]

I have two sets of revenue numbers and I want to do an Index 100 chart (so that both numbers are indexed to 100 at the start)...

1996 1997 1998 1999 2000
500 700 900 1,100 1,200
900 900 900 900 900

etc. etc.

I'm not sure how the INDEX formula works or how to chart this to show the top number doubling with the other line stays near the 100 line.

 

[jpgordo]

Any advice? The Help area of Excel on Index is a mess...

 

[Juan Pablo González]

I don't believe that INDEX is what you're looking for. INDEX returns a specific value from a matrix, using its row and column "coordinates". I don't seem to understand what you're trying to do, can you explain a little further ?

 

[Parra]

I am not sure if this is what you want but to make the first number in your column to go up by 200. In cell A2 you would type the initial value of 500 then in cell B2 type in the formula A2+200 and then just click and drag and each year it would go up by 200.

Then just select the data and click on the chart wizard. It will do all the work for you.

I hope this helps.

 

[jpgordo]

With the fixed numbers that are listed under the year 1996-2001 I want to be able to see the growth on an equal basis (on an Index of 100) - so that one line will show upward growth while the other remains stagnant.

 

[jpgordo]

I'm sorry not I'm explaining this right...

Basically, on the above numbers - under 1996 - 500 and 900 I want to equal 100 to start - and then two trend lines will start from the same place. One line with growth and the other flat.
This message was edited by jpgordo on 2002-09-04 17:52

 

[Juan Pablo González]

Try charting the range in A6:E7 to see if that's what you need.

Book1
	A	B	C	D	E
1	1996	1997	1998	1999	2000
2	500	700	900	1100	1200
3	900	900	900	900	900
4
5
6	100	140	180	220	240
7	100	100	100	100	100
Sheet1