Thread: Indexing Values to Same Starting Point for Relative Return Chart

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.

> Do I have to manipulate the data in another sheet first?

Yes.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Notclevr" <Notclevr.21u78n_1137598802.034@excelforum-nospam.com> wrote in
message news:Notclevr.21u78n_1137598802.034@excelforum-nospam.com...
>
> 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.
>
>
> --
> Notclevr
> ------------------------------------------------------------------------
> Notclevr's Profile:
> http://www.excelforum.com/member.php...o&userid=30597
> View this thread: http://www.excelforum.com/showthread...hreadid=502481
>