Hi,
I need to create graphs but my raw data is stored in a table that has so many columns it unwieldy, so I was hoping to create another table that just lists all the rows of data, but on the columns I intend to plot. Since all my raw data is based on timestamps - that column A will be the same in both tables, then I will just V-Lookup from that column.
I also need the table to be dynamic so that as new rows are added to the raw data table, my chart table updates as well.
Unfortunately I can't find a simple way of getting my chart table to reference the raw data since if I just do a simple = function and drag down, it will grow the table despite there being no data in the referencing cell.
Any ideas?
Thanks
Bookmarks