Dynamic Chart That Allows for Manipluation of Both, X and Y, Axis from Drop-Down List

Can anyone help me to create a dynamic chart that lets a user manipluation both, X and Y, axis from drop-down list? I have already figured out how to create a dynamic chart that allows me to manipulate the Y-axis from a drop down, but I cannot figure out how to include the X-axis.

I have attached an example of the file I am currently working with. Presently, I am able to switch between "Distance" and "ROP" on the Y-axis, with "Type" on the X-axis. However, my goal is to move add "Hours" to the X-axis as an alternative to "Type" ("Hours" is currently an Y-axis alternative, but again I want it on the X-axis).

Thanks in advance for your time! Tisha

Hi Tisha
Not sure if you're still looking for a possible solution to your post, as it's a day or so old but take a look at the attached file, which is an amended version of your example. It uses the Choose Function and a couple of Dynamic named ranges to hopefully achieve what you're looking for.

Hope this helps.
DBY

Wow! I have not had time to look at your file in depth, but what I saw in brief looks really good! I will look it through tomorrow and respond back.
Thank you so much for your time! I am really excited to have a look. Kind Regards, Tisha

Sorry I am just now responding. I have been through your file and have now incorporated it into my working file. It works like a charm! Thank you so much for your help, I truly appreciate your time!

Here's the attachment to your private message about a possible dynamic secondary axis.