Skip to main content

Looking to chart a series of data points over time with the following structure.


Column A = Week Start

Column B-G = data points which are items in numbers/hr that relate to one another and would be helpful to see everything in one graph.


Is this possible??


Note: I am aware I could do this in a 3 column base that was structured as follows:

Column A = Week Start

Column B = Tag to modify data

Column C = Data point


The problem with this method is the data is no longer human visible as a table and the number of rows would multiple by 6x. I am also not sure how we would automate data entry in this method. Currently we have a system on another sheet that creates the Week Start that fills this sheet and all of the numbers auto fill. That is a necessity, it would not be possible to manually enter this much data specially in this 3 column format.


This might help.



Reply