Hello all,

I'm have a sheet full of data for various securities that is sorted by date. I can chart the values by date just fine, but I'm hoping to create a chart where each series is indexed to the same point and then the chart will show percentage changes. For instance, if A is at 300 and B is at 40 on January 1st, then in my chart I want them both to start at 100. So if A falls to 150 and B moves up to 80, then I would want the chart to show them moving to 50 and 200, respectively.

Do I have to manipulate the data in another sheet first, or is there a way to do it with the charting tools? I have another problem that would make manipulating the data hard, which I will post next.