Peter Turner
New Member
Hi,
I need to create a chart which automatically changes the number of data points each month. The titles and rows for the data set are aleready in place (they are part of a sheet with moe info on it).
What I want to do is sort of like the OFFSET function to determine the number of points to show. However, instead of using COUNTA I want to determine the number of points to show by referring to a value stored in a cell.
I've tried adapting the method from another Chandoo thread, http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/ , but without success.
I'd be really grateful for any help...
Peter
I need to create a chart which automatically changes the number of data points each month. The titles and rows for the data set are aleready in place (they are part of a sheet with moe info on it).
What I want to do is sort of like the OFFSET function to determine the number of points to show. However, instead of using COUNTA I want to determine the number of points to show by referring to a value stored in a cell.
I've tried adapting the method from another Chandoo thread, http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/ , but without success.
I'd be really grateful for any help...
Peter