+ Reply to Thread
Results 1 to 2 of 2

Scatter Plot with points fading over time

  1. #1
    Registered User
    Join Date
    06-18-2013
    Location
    New York, New York
    MS-Off Ver
    Excel 2010
    Posts
    5

    Scatter Plot with points fading over time

    Currently I'm regressing two values (call it x and y) that are time series ordered pairs. I was wondering if there was a way to add a representation of this third dimension (time) to the scatter plot regression. One thought was to have the individual x,y points fade as they get older.


    Not necessary to get caught up in the details, but for context:
    I am regressing values of financial instruments. As time changes, the relationship tends to adjust to "new regimes." It would would be nice to see if the current pair value is simply off from the model due to a short term market mispricing, or if the current deviation from the model mean is due to the relationship shifting in to a new regime (ie. many of the recent points are clustered in the same area away from the model mean. This implies that going forward the model will adjust towards the more recent points, as opposed to the pair reverting back towards the model mean.)


    Any and all suggestions welcome (even if conceptual instead of technical.) Thanks all.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Scatter Plot with points fading over time

    Two thoughts that are kind of similar. In either case, most of the work is in the spreadsheet, and the chart is there to reflect what you do in the spreadsheet.

    1) use a bubble chart rather than an XY scatter chart. A bubble chart is very similar to a scatter chart, but it also incorporates a "size" parameter for each data point. Devise some suitable logic/formula that will relate size to age (probably in a way that newer is larger). It will probably need some time and tinkering to get a feel for how best to utilize size.
    2) Still using a scatter chart but with "conditional formatting" based on age. Just about every discussion about conditional formatting a chart begins with something like this: https://peltiertech.com/conditional-...-excel-charts/ where you would have different columns for different age categories and format those data series as desired.

    Either of those seems like an easy way to incorporate age into your chart. Which one do you like and what questions do you have about implementing it?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Add year to data points on scatter plot
    By Justair07 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-08-2015, 05:30 AM
  2. Identifying Points in a Scatter Plot
    By jbianco51 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-20-2014, 04:42 PM
  3. Show interval points on scatter plot
    By dpkennedy24 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-05-2014, 09:24 AM
  4. Label Points on Hover ONLY in Scatter Plot
    By elastica1234 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-22-2012, 02:57 PM
  5. Only plot scatter points that have both an X and a Y value (2007)
    By JayUSA in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-15-2009, 04:23 AM
  6. Excel 2007 : Labelling Data Points on a Scatter Plot
    By SDruley in forum Excel General
    Replies: 3
    Last Post: 06-01-2009, 09:56 AM
  7. [SOLVED] Scatter plot points x and y coordinates
    By Milo in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-28-2005, 07:25 PM

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