Dynamic Columns

[funny_bunny]

Is it possible to create stacked dynamic columns in Excel that show current data point, data point from last 30 seconds, 1 minute and 1.5 minutes.
Basically, I want every dynamic column in a chart to display overlay of data from the recent past along with the current data.
Please see attached image, I think it explains better.

The gray bars represent data from 30 seconds, 1 minute and 1.5 minutes (progressively more gray with time).
Purple and yellow bars represent current real-time data.

The data set used will be real-time streaming data.

 

[Worf]

Welcome to the Board



The chart below can be used as a template, it is now a matter of plugging the streaming data into the table.

Concerning that, can you provide more details on how your worksheet receives the data? What is the range layout used? We need to connect it to the chart’s source range.

Are you going to need positive and negative values for the same x position?