SelinaR
Board Regular
- Joined
- Feb 2, 2012
- Messages
- 65
- Office Version
- 2021
- Platform
- Windows
- Mobile
- Web
I have a mileage chart that runs on an x and a y-axis and need to have a drop-down that picks up a TO and FROM but in the correct axis.
I have tried multiple options but because the data has two prices (city to country and country to the city) I can't find a solution.
I have made a drop-down box for from and to but as there are two sets of data, how can I build a formula to pick up the correct axis.?
Thanks so much in advance for your help
I have tried multiple options but because the data has two prices (city to country and country to the city) I can't find a solution.
I have made a drop-down box for from and to but as there are two sets of data, how can I build a formula to pick up the correct axis.?
Thanks so much in advance for your help