Visualization of data with tails

Rotation Matrix screenshot latest.png

I have some data which i have made into a scatter chart with a tail.

In the case of the data you can see in the attached image, there is TODAYS data, and 2 other days of data. What function could i use so that i have a little dropdown menu and can select a number such as 3, 5, 10, 20 etc and then the chart updates to select 3,5,10 or 20days of data from my data to update the visualisation?

Also, is there a way to create quadrants on this image, and specify where the lines start and finish?

Many thanks in advance

Mark

On the attached excel file, I HAVE plotted all 4 data sets on a scatter plot with a tail
So I have included 12/07/2021, 08/07/2021, and 07/07/2021

If I plotted more on one chart (for example 20 or more dates with many securities) it will start to look like spaghetti.

My question is how can I create a drop down or sort of toggle so I can press up or
down on arrow key and then it would move the dates (3 at a time or however many i want), so we can see those arrows move on the chart as selected range moves on the table?

for example I would click down arrow and then we could see 08/07/2021, 07/07/2021
and 06/07/2021, instead of 12/07/2021, 08/07/2021, and 07/07/2021 as we do now?


How do i upload an excel spreadsheet?

Hi Richard, ok i did it! Many thanks in advance
Best
Mark

Hi Richard
If you see RRG charts on the stockchart website (I'm not being allowed to post the URL here)
and click animate on the RRG charts and then you will see how it automates running through the history of stocks versus one another.
I didn't want to automate it so much as they do, but I'd like to be able to do that in a controlled way going through dates by toggling up and down
Best
Mark

Hi Mr Shorty
Yes the link you posted is correct (I still cannot post or repost).
I do not need to match the stockcharts interface at all. I do not want to complicate my life by using a 3rd party.

I just simply want to be able to take lets say 3 data points for each stock (let's say that represents 3 days or the points on the chart) and then let's say that i am plotting BDRY etf and QQQ etf on that chart from December 01. On the chart i can see Dec 1,2,3 on the chart with an arrow on Dec 3rd to show the direction at that point in time....

Then i just want to be able to easily select one day forward, and then another day forward so its always rolling forward with the last 3 days, i.e. Dec 2nd, 3,4th, then Dec 3rd,4,5th......so i would be able to see the data moving around on that chart like a little worm with an arrow....and i can see how it evolved until now.

Is that possible?

I didn't understand how to select data series and format the chart so that does NOT move or size with cells.
Also i didnt understand about turning on autofilter.


Is it possible to show me in my excel spreadsheet?

Best regards
Mark

Actually i tried your suggestion of highlighting the data in cells DI 2 to DN 51 which is SPY,
SLY, QQQ stocks
Then i clicked on filter which gives me the little drop down arrows.

Then i changed the data to highlight just, say, February data....then the table disappears to
just the month or months i try, but the chart remains the same, or just completely disappears.

First, i'd like to try to get this working so i can see how it works.

Second, i'd like to ask if there is a less cumbersome way of doing it?
I mean currently if it worked, i would have to click the down arrow and keep clicking and
adjusting....id really rather just be able to tap my down or up or side arrow and then for the
date to adjust on a rolling basis like i explained in my previous message.

What do you think?

Best
Mark