N
Notclevr
Hello all,
I'm have a sheet full of data for various securities that is sorted b
date. I can chart the values by date just fine, but I'm hoping t
create a chart where each series is indexed to the same point and the
the chart will show percentage changes. For instance, if A is at 30
and B is at 40 on January 1st, then in my chart I want them both t
start at 100. So if A falls to 150 and B moves up to 80, then I woul
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
way to do it with the charting tools? I have another problem tha
would make manipulating the data hard, which I will post next
I'm have a sheet full of data for various securities that is sorted b
date. I can chart the values by date just fine, but I'm hoping t
create a chart where each series is indexed to the same point and the
the chart will show percentage changes. For instance, if A is at 30
and B is at 40 on January 1st, then in my chart I want them both t
start at 100. So if A falls to 150 and B moves up to 80, then I woul
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
way to do it with the charting tools? I have another problem tha
would make manipulating the data hard, which I will post next