Index Chart

jpgordo

New Member
Joined
Sep 2, 2002
Messages
4
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

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Juan Pablo González

MrExcel MVP
Joined
Feb 8, 2002
Messages
11,959
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

Well-known Member
Joined
Feb 21, 2002
Messages
752
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

New Member
Joined
Sep 2, 2002
Messages
4

ADVERTISEMENT

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

New Member
Joined
Sep 2, 2002
Messages
4
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
 

Forum statistics

Threads
1,144,311
Messages
5,723,643
Members
422,508
Latest member
Lordkit1

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

Which adblocker are you using?

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
Top