+ Reply to Thread
Results 1 to 2 of 2

Indexing Values to Same Starting Point for Relative Return Chart

  1. #1
    Registered User
    Join Date
    01-18-2006
    Posts
    3

    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.

  2. #2
    Jon Peltier
    Guest

    Re: 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" <[email protected]> wrote in
    message news:[email protected]...
    >
    > 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1