Axes formatting XY graph

Hi,

I am trying to create a dynamic XY graph once with dates in X axis and once with "No. of weeks". See the attached example sheet; Is it possible...

1. to set the formatting of X axis to change with the selection. (i.e to date format when choosing date and number format when choosing no. of weeks).

2. In case of city D and E, choose only the cells with data and ignore the blank cells?

Thanks in advance.