Shweta Nair
New Member
Hi ,
I request assistance in my below query.
I have a data of years (2015,2016) and months for joiner and resignee in a company.
My aim is to plot the data on a chart basis user selection. I have given a list box where the user can select year and whether he/she wants joiner, resignee or both(joiner and resignee).
1. User will select required year.
2. Then user will select if :
I have achieved plotting chart for requirement 2a and 2b.
For requirement 2c , I had written a separate two Offset formula.( one for joinee range column selection in chart) and other for resignee range in chart.
I then tried to combine all the formula using If criteria.
I have done several trials and variations of the IF formula to determine what the user has selected . But none of the achieve the desired result. I also get a number of named reference errors while trying to achieve requirement 2c.
I have attached the excel file.
Kindly assist.
Regards
Shweta Nair
I request assistance in my below query.
I have a data of years (2015,2016) and months for joiner and resignee in a company.
My aim is to plot the data on a chart basis user selection. I have given a list box where the user can select year and whether he/she wants joiner, resignee or both(joiner and resignee).
1. User will select required year.
2. Then user will select if :
a) He wants joinee for that year Or
b) He wants Resignees for that year Or
c) He wants both joinee and resignee for that year
b) He wants Resignees for that year Or
c) He wants both joinee and resignee for that year
I have achieved plotting chart for requirement 2a and 2b.
For requirement 2c , I had written a separate two Offset formula.( one for joinee range column selection in chart) and other for resignee range in chart.
I then tried to combine all the formula using If criteria.
I have done several trials and variations of the IF formula to determine what the user has selected . But none of the achieve the desired result. I also get a number of named reference errors while trying to achieve requirement 2c.
I have attached the excel file.
Kindly assist.
Regards
Shweta Nair