Hi All,
I have a question on what you think would be the best way to solve a problem that I have...
I have attrition numbers for 12 months in columns and City_Tenure in the Rows, it looks something like this....
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I am planning on using a list box to select the cities in my data set to show the City and Tenure by Month on an Excel graph. I guess my issue is just grabbing City 1 and plotting that by month alone - would this be done by the Data Validation Function, and would there be a better way to set up the data?
Thank you for your help.
Diesel24
I have a question on what you think would be the best way to solve a problem that I have...
I have attrition numbers for 12 months in columns and City_Tenure in the Rows, it looks something like this....
| Code | ATTRITION_Jan_18 | ATTRITION_Feb_18 | ATTRITION_Mar_18 |
| City 1_0-30 | #N/A | #N/A | #N/A |
| City 1_31-90 | #N/A | #N/A | #N/A |
| City 1_91-180 | #N/A | #N/A | #N/A |
| City 1_180-365 | #N/A | #N/A | #N/A |
| City 1_366+ | #N/A | #N/A | #N/A |
| City 1_All-in | #N/A | #N/A | #N/A |
| City 2_366+ | #N/A | #N/A | #N/A |
| City 2_All-in | #N/A | #N/A | #N/A |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I am planning on using a list box to select the cities in my data set to show the City and Tenure by Month on an Excel graph. I guess my issue is just grabbing City 1 and plotting that by month alone - would this be done by the Data Validation Function, and would there be a better way to set up the data?
Thank you for your help.
Diesel24
