Hello,
I used a scatter plot to create a time line. It is based on a dynamic data.
Every time I change the data set to show a different project, I have to readjust the graph size to make it smaller or larger based on the size of the data set.
Does anyone know if there is a way to have the chart dynamically change with the data set?
I used the following array formula to pull the information into the chart.
=IF(ROWS(B$7:B7)>$B$4,"",INDEX(Tasks!B$3:B$75,SMALL(IF(Tasks!$A$3:$A$75=$B$2,IF(Tasks!$B$3:$B$75=$B$3,ROW(Tasks!$B$3:$B$75)-ROW(Tasks!$B$3)+1)),ROWS(B$7:B7))))
Thanks,
RCAAA
I used a scatter plot to create a time line. It is based on a dynamic data.
Every time I change the data set to show a different project, I have to readjust the graph size to make it smaller or larger based on the size of the data set.
Does anyone know if there is a way to have the chart dynamically change with the data set?
I used the following array formula to pull the information into the chart.
=IF(ROWS(B$7:B7)>$B$4,"",INDEX(Tasks!B$3:B$75,SMALL(IF(Tasks!$A$3:$A$75=$B$2,IF(Tasks!$B$3:$B$75=$B$3,ROW(Tasks!$B$3:$B$75)-ROW(Tasks!$B$3)+1)),ROWS(B$7:B7))))
Thanks,
RCAAA