Alternating Between Data Sources in Dynamic Chart

[Arashikage]

I’ve been banging my head against the wall trying to figure this out I don’t have any training in Excel or VBA. Everything I’ve ever learned to do in Excel has been from looking stuff up online or picking apart other people’s spreadsheets to see how they did something. My problem…

I created a table named ‘TrendDatabase’ that I input data into daily. There are 100+ columns of data. For my example I reduced it to four and renamed the columns. I defined all of the column headers except for the “Date” column as ‘Categories’. I then created a drop-down list that uses ‘Categories’ as its source (to exclude the “Date” column I couldn’t use =TrendDatabase[#Headers] as my source for the list). I also defined the cell that has the drop-down list as ‘ChartCategory’.

I want to be able to select a category in the drop-down list and have only that category’s data appear in a line chart. I know of a convoluted way to do this with a static amount of rows, but I want to be able to filter the data and only see that filtered data on the chart. I also don’t want to have large blank sections on the chart, so the chart range would have to be dynamic.

This is just a basic view of what I'm working with. If anyone could answer this or would care to take on this challenge, please do.
Excel 2007

	A	B	C	D	E	F	G	H
1								Pick Category…
2		Date	A	B	C	D		B
3		8/24/16	1,915	1,183	60.6%	10,901
4		8/25/16	1,713	1,230	62.9%	10,780
5		8/26/16	1,905	1,275	64.7%	11,313
6		8/29/16	1,828	1,316	63.8%	10,778
7		8/30/16	1,896	1,283	59.5%	11,737
8		8/31/16	1,866	1,212	60.8%	10,782
9		9/1/16	1,874	1,309	63.3%	11,374
10		9/2/16
11		9/5/16
12		9/6/16	1,776	1,300	55.5%	9,873
13		9/7/16	1,588	1,179	64.7%	8,681
14		9/8/16	1,730	1,331	62.1%	2,951
15		9/9/16
16		9/12/16	1,687	1,214	68.1%	7,743
17
18

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Trend Data​

 

[cyrilbrd]

Hi,
Have you considered creating a pivot table from your table and using this PT to create your chart?
read this regarding PT.