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 data linked 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). Based on the drop down, the chart would auto adjust.
I’m trying to create the second chart on the tab called “TenureBand (Miles – Graphs)” using the data on tab “Tenure Band (Miles). Ideally Iwould like to select from a drop like the one previously reference. Based onthe drop down, the chart would auto adjust.
I’ve tried to use an index and match function, but I’mmissing something. REF errors. Any assistance anyone can provide would beGREATLY appreciated. Thank you.
I'm trying to create two different types of dynamic charts using the data linked 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). Based on the drop down, the chart would auto adjust.
I’m trying to create the second chart on the tab called “TenureBand (Miles – Graphs)” using the data on tab “Tenure Band (Miles). Ideally Iwould like to select from a drop like the one previously reference. Based onthe drop down, the chart would auto adjust.
I’ve tried to use an index and match function, but I’mmissing something. REF errors. Any assistance anyone can provide would beGREATLY appreciated. Thank you.
