I have a csv file that collects time series data for measuring correlations. The top correlations included in the dynamic table (changes each week). Therefore the column headers will change each week according to the ranking of the strength of the correlation.
I am creating charts to plot the time series correlations of the 2 datasets. However, since the rankings change each week the headers of the csv file also change.
How can I have the charts that are associated with the table update the labels for the data series in accordance with the update that occurs with the table? See attached image for reference
Unfortunately this can't be done. We can manage a CSV file that has dynamic cells, but headers can't be changed, rearranged, removed or added, or the table will break.
If there is anything else we can assist you with please don't hesitate to contact us.
I have a csv file that collects time series data for measuring correlations. The top correlations included in the dynamic table (changes each week). Therefore the column headers will change each week according to the ranking of the strength of the correlation.
I am creating charts to plot the time series correlations of the 2 datasets. However, since the rankings change each week the headers of the csv file also change.
How can I have the charts that are associated with the table update the labels for the data series in accordance with the update that occurs with the table? See attached image for reference
Hi Terry
Thank you for reaching out to us.
Unfortunately this can't be done. We can manage a CSV file that has dynamic cells, but headers can't be changed, rearranged, removed or added, or the table will break.
If there is anything else we can assist you with please don't hesitate to contact us.