https://drive.google.com/file/d/1aYHDusIlfizyXRo8-GWl9xhRpZww-ajB/view?usp=sharing
I'm trying to create two different types of dynamic charts using the datalinked above. I cannot attach files.
I'm trying to create the first chart on the tab called "Tenure Band (Hours- Graphs)" using the data on tab "Tenure Band (Drive Hours). Ideally,I would like to select from a drop down: Avg. Drive Hours (0-90 Days); Avg.Drive Hours (91-180 Days; Avg. Drive Hours (181-364 Days); Avg. Drive Hours(1-2 Years); Avg. Drive Hours (2-7 Years); Avg. Drive Hours (7+ Years). Basedon the drop down, the chart would auto adjust.
I’mtrying to create the second chart on the tab called “Tenure Band (Miles –Graphs)” using the data on tab “Tenure Band (Miles). Ideally, I would like toselect from a drop like the one previously reference. Based on the drop down,the chart would auto adjust.
I’vetried to use an index and match function, but I’m missing something. REF errors.Any assistance anyone can provide would be GREATLY appreciated. Thank you
I'm trying to create two different types of dynamic charts using the datalinked above. I cannot attach files.
I'm trying to create the first chart on the tab called "Tenure Band (Hours- Graphs)" using the data on tab "Tenure Band (Drive Hours). Ideally,I would like to select from a drop down: Avg. Drive Hours (0-90 Days); Avg.Drive Hours (91-180 Days; Avg. Drive Hours (181-364 Days); Avg. Drive Hours(1-2 Years); Avg. Drive Hours (2-7 Years); Avg. Drive Hours (7+ Years). Basedon the drop down, the chart would auto adjust.
I’mtrying to create the second chart on the tab called “Tenure Band (Miles –Graphs)” using the data on tab “Tenure Band (Miles). Ideally, I would like toselect from a drop like the one previously reference. Based on the drop down,the chart would auto adjust.
I’vetried to use an index and match function, but I’m missing something. REF errors.Any assistance anyone can provide would be GREATLY appreciated. Thank you
