Hello,
I am essentially building a dashboard that pulls data from the "Yellow picture". My "Time Spent versus time allocated" chart only pulls inputted values. I want my chart to grab data on the "Time spent versus time allocated" chart from K35:N60 but only using data once it is inputted so it will not have 20+ bars showing values of 0. So im wondering if there is a way to tell the chart when to select data.
K33==IF(ROW()-ROW(K$34)<=SUM(IFERROR(--(('Project - Gantt Chart'!$B$9:$B$45/INT('Project - Gantt Chart'!$B$9:$B$45))=1),"")),ROW()-ROW(K$34),"")
L33==IFERROR(INDEX('Project - Gantt Chart'!$B$9:$I$45,MATCH('Executive Summary'!$K35,'Project - Gantt Chart'!$B$9:$B$45,0),4),"")
M33==IFERROR(INDEX('Project - Gantt Chart'!$B$9:$I$45,MATCH('Executive Summary'!$K35,'Project - Gantt Chart'!$B$9:$B$45,0),5),"")
N33==IFERROR(INDEX('Project - Gantt Chart'!$B$9:$I$45,MATCH('Executive Summary'!$K35,'Project - Gantt Chart'!$B$9:$B$45,0),8),"")
Thank you.
I am essentially building a dashboard that pulls data from the "Yellow picture". My "Time Spent versus time allocated" chart only pulls inputted values. I want my chart to grab data on the "Time spent versus time allocated" chart from K35:N60 but only using data once it is inputted so it will not have 20+ bars showing values of 0. So im wondering if there is a way to tell the chart when to select data.
K33==IF(ROW()-ROW(K$34)<=SUM(IFERROR(--(('Project - Gantt Chart'!$B$9:$B$45/INT('Project - Gantt Chart'!$B$9:$B$45))=1),"")),ROW()-ROW(K$34),"")
L33==IFERROR(INDEX('Project - Gantt Chart'!$B$9:$I$45,MATCH('Executive Summary'!$K35,'Project - Gantt Chart'!$B$9:$B$45,0),4),"")
M33==IFERROR(INDEX('Project - Gantt Chart'!$B$9:$I$45,MATCH('Executive Summary'!$K35,'Project - Gantt Chart'!$B$9:$B$45,0),5),"")
N33==IFERROR(INDEX('Project - Gantt Chart'!$B$9:$I$45,MATCH('Executive Summary'!$K35,'Project - Gantt Chart'!$B$9:$B$45,0),8),"")
Thank you.