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.
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.