Hello all,
I'd appreciate any help solving the below mystery...
I'm using Excel 2016 (in Windows) and have the 3D Maps functionality for the first time. I want to show progress over time by adding both location data (address inc. postcode or just postcode) and the date or month that point was added.
If I do it as the very first step, I can select "Start Date" (the name of my field) in the Time field, so clearly it is recognising my data correctly as a date.
I can then add my postcode/zip field (and/or any other geographic data field) from my Field List to the location field and the time field stays.
However if I then select the associated drop-down label(s) for the location field(s) e.g. "Postal Code" the time field disappears.
If I do the geographic data and select the associated drop-down labels as the first step, it doesn't allow me to add a time field at all. (Clicking on "Add Field" under Time does nothing.)
Many thanks for any thoughts
I'd appreciate any help solving the below mystery...
I'm using Excel 2016 (in Windows) and have the 3D Maps functionality for the first time. I want to show progress over time by adding both location data (address inc. postcode or just postcode) and the date or month that point was added.
If I do it as the very first step, I can select "Start Date" (the name of my field) in the Time field, so clearly it is recognising my data correctly as a date.
I can then add my postcode/zip field (and/or any other geographic data field) from my Field List to the location field and the time field stays.
However if I then select the associated drop-down label(s) for the location field(s) e.g. "Postal Code" the time field disappears.
If I do the geographic data and select the associated drop-down labels as the first step, it doesn't allow me to add a time field at all. (Clicking on "Add Field" under Time does nothing.)
Many thanks for any thoughts
