Alternating Between Data Sources in Dynamic Chart

A

Arashikage

New Member
Joined
Sep 14, 2016
Messages
1
I’ve been banging my head against the wall trying to figure this out :banghead: 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
ABCDEFGH
Pick Category…

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: center"]Date[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #DBE5F1, align: center"]B[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: center"]8/24/16[/TD]
[TD="align: center"]1,915[/TD]
[TD="align: center"]1,183[/TD]
[TD="align: center"]60.6%[/TD]
[TD="align: center"]10,901[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="align: center"]8/25/16[/TD]
[TD="align: center"]1,713[/TD]
[TD="align: center"]1,230[/TD]
[TD="align: center"]62.9%[/TD]
[TD="align: center"]10,780[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="align: center"]8/26/16[/TD]
[TD="align: center"]1,905[/TD]
[TD="align: center"]1,275[/TD]
[TD="align: center"]64.7%[/TD]
[TD="align: center"]11,313[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"][/TD]
[TD="align: center"]8/29/16[/TD]
[TD="align: center"]1,828[/TD]
[TD="align: center"]1,316[/TD]
[TD="align: center"]63.8%[/TD]
[TD="align: center"]10,778[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: right"][/TD]
[TD="align: center"]8/30/16[/TD]
[TD="align: center"]1,896[/TD]
[TD="align: center"]1,283[/TD]
[TD="align: center"]59.5%[/TD]
[TD="align: center"]11,737[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]
[TD="align: right"][/TD]
[TD="align: center"]8/31/16[/TD]
[TD="align: center"]1,866[/TD]
[TD="align: center"]1,212[/TD]
[TD="align: center"]60.8%[/TD]
[TD="align: center"]10,782[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="align: right"][/TD]
[TD="align: center"]9/1/16[/TD]
[TD="align: center"]1,874[/TD]
[TD="align: center"]1,309[/TD]
[TD="align: center"]63.3%[/TD]
[TD="align: center"]11,374[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="align: right"][/TD]
[TD="align: center"]9/2/16[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]
[TD="align: right"][/TD]
[TD="align: center"]9/5/16[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]
[TD="align: right"][/TD]
[TD="align: center"]9/6/16[/TD]
[TD="align: center"]1,776[/TD]
[TD="align: center"]1,300[/TD]
[TD="align: center"]55.5%[/TD]
[TD="align: center"]9,873[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]
[TD="align: right"][/TD]
[TD="align: center"]9/7/16[/TD]
[TD="align: center"]1,588[/TD]
[TD="align: center"]1,179[/TD]
[TD="align: center"]64.7%[/TD]
[TD="align: center"]8,681[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]
[TD="align: right"][/TD]
[TD="align: center"]9/8/16[/TD]
[TD="align: center"]1,730[/TD]
[TD="align: center"]1,331[/TD]
[TD="align: center"]62.1%[/TD]
[TD="align: center"]2,951[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]
[TD="align: right"][/TD]
[TD="align: center"]9/9/16[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]
[TD="align: right"][/TD]
[TD="align: center"]9/12/16[/TD]
[TD="align: center"]1,687[/TD]
[TD="align: center"]1,214[/TD]
[TD="align: center"]68.1%[/TD]
[TD="align: center"]7,743[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>
Trend Data​
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

Z
  • Question Question
Chart with Dynamic Ranges
2
Replies
11
Views
736
awoohaw
awoohaw
M
  • Question Question
Chart Source Data Query
Replies
0
Views
470
M10Ant
M
H
  • Question Question
Dynamic charting when data table is horizontal instead of vertical
Replies
0
Views
597
Hawk11ns
H
N
  • Question Question
Dynamically adding and updating Conditional Formatting with a Named Range
Replies
0
Views
526
naquinn
N
S
  • Question Question
Pulling list of Unique Names from Refresh-able Table between Date Range (Or Month Number)
Replies
3
Views
599
DanteAmor
DanteAmor

Forum statistics

Threads
1,223,723
Messages
6,174,123
Members
452,546
Latest member
Rafafa

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top