Hi Sir / Madam
I have a config file which says which engineer is assigned to what location I get salespersons data ( Sales, expenditure and ROI). For many tens of salesmen, I have to append the relevant location as documented in the two coloums (Attached is the file).
Now I need help based on the location, conditional charting wherein any ROI less than 20,000 should be the histogram should be red in color.
I also need help in getting the average ROI as a horizontal line in different color.
I need to collect location based ROI for several week progressively to be ready to show trend anaalysis later.
Please can you help me.. The problem and my requirements are captured in the attached sheet.
Regards
Anand
I have a config file which says which engineer is assigned to what location I get salespersons data ( Sales, expenditure and ROI). For many tens of salesmen, I have to append the relevant location as documented in the two coloums (Attached is the file).
Now I need help based on the location, conditional charting wherein any ROI less than 20,000 should be the histogram should be red in color.
I also need help in getting the average ROI as a horizontal line in different color.
I need to collect location based ROI for several week progressively to be ready to show trend anaalysis later.
Please can you help me.. The problem and my requirements are captured in the attached sheet.
Regards
Anand