# Index Chart

#### jpgordo

##### New Member
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.

### Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Any advice? The Help area of Excel on Index is a mess...

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 ?

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.

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.

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

Try charting the range in A6:E7 to see if that's what you need.
Book1
ABCDE
119961997199819992000
250070090011001200
3900900900900900
4
5
6100140180220240
7100100100100100
Sheet1

Replies
3
Views
559
Replies
1
Views
542
Replies
8
Views
626
Replies
0
Views
393
Replies
4
Views
455

Threads
1,218,560
Messages
6,143,200
Members
450,469
Latest member
brent3162

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back