Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
How to chart a single column of values similar to a GROUP BY | Charts and Charting in Excel | |||
Scatter chart without numerical values | Charts and Charting in Excel | |||
Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
linked values in a chart | Charts and Charting in Excel |