showing daily data per month using a dropdown list

[ACrossley1]

Hi.

I have a table for a number of variables which has each day for a whole year. I want to create a graph for eahc variable which shows the daily data for each variable.

Im trying to create a linked dropdown list where i can change my graph by month.

So when i click september it only shows 1st Sep to 30th Sep etc.

How do i do this? Im not sure where to start.

[JeteMc]

One option might be to use Get & Transform (Power Query)
Select one cell in the table
Select From Table/Range on the Data tab
Select OK in the Create Table dialog box.
Use the following advanced editor code in Power Query:

Please Login or Register  to view this content.

Note that Excel will name each table (i.e. Table 1) but that you may change the name to one that is easier to remember.
Place the resulting table on its own sheet (i.e. Top Speed)
Select one cell in the table to produce a pivot table (Alt + n + v)
Pull Date and Names to Rows area and then pull Months to Filters area and uncheck Date.
Pull Speed to Values area and select how you want them summarized (I chose to summarize by average).
Select Pivot Chart from the Pivottable Tools > Analyze sub tab.
Let us know if you have any questions.