I would like to create a chart with 2 or more data series selections. These series' would be identical but offset by a specific distance along the horizontal axis. I currently create multiple columns to derive each selection from. The data is simply shifted by a given number of rows to create the offset with regard to time. This is the most accurate way I know of to maintain the correct separation of each series but is time consuming to update the chart.
It seems there must be a way to make just one selection of the data for a given chart > create multiple instances of the selection > offset each instance as required for proper time separation along the H axis.
I use the term 'offset' but I do not know if it would be used here.
I can attach a sheet if Im not being clear enough here. Im just assuming its a rather simple task.
Thank you.