Dynamic Chart with Dropdown Lists

hi aldo23, welcome to the forum. i see that you have Named Ranges with OFFSET, so i guess it's not unfamiliar to you. i added 2 more:
Date:
=OFFSET($A$1,,MATCH($B$10,$B$1:$CX$1,0),,MATCH($D$10,$B$1:$CX$1,0)-MATCH($B$10,$B$1:$CX$1,0)+1)
Desk:
=OFFSET($A$2,MATCH($F$10,$A$3:$A$6,0),MATCH($B$10,$B$1:$CX$1,0),,MATCH($D$10,$B$1:$CX$1,0)-MATCH($B$10,$B$1:$CX$1,0)+1)

then right-click the chart & "Select Data". Edit the range. be sure to have the worksheet name in front before the Named Range. the series & categories will be like this:
='Sales Example.xlsx'!Desk
='Sales Example.xlsx'!Date

you're very welcome~

I just have one quick question...Am I right in saying that I can replace the range $B$1:$CX$1 in the MATCH function with a dynamic range so that when I add more dates it will expand automatically?

i'm supposing you are referring to your "Range" OFFSET formula. yes you can.

It appears on your name range though you need to add a minus 1 on the end...

=OFFSET(Sales!$B$1,0,0,1,COUNTA(Sales!$1:$1)-1)

Without the minus 1 the range selects from B1:CY

Good work benishiryo.

===========================================

Please don't forget to mark your thread as solved.

I guess all is good then