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.


--
Notclevr
------------------------------------------------------------------------
Notclevr's Profile: http://www.excelforum.com/member.php...o&userid=30597
View this thread: http://www.excelforum.com/showthread...hreadid=502481

Indexing Values to Same Starting Point for Relative Return Chart
 

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" wrote in
message ...

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