Bar Chart in Excel

[Prasad Vanka]

Hi,

Can someone guide me in achieving the below:

There are 4 sales persons each set a target for a financial year (Apr
- Mar) between 0 to 1000 pounds.

Each sales persons performance should be displayed as a bar chart
showing year-to-date monthly performance compared to his monthly
target. The chart shows the mean performance to date, and at the end
of the financial year, the mean performance for the year is used to
calculate an annual bonus.

My task is as follows:
I need to build this chart containing:
1. Sales performance to date for a specified salesperson.
- where a month's performance falls below the target, it must be
shown in red
- where a month's performance is at or above the target, it must be
shown in green
2. The mean performance to date
- where the mean falls below the target, it must be shown in red
- where the mean is at or above the target, it must be shown in green
3. An indication of the performance target for each individual
- the target must be entered dynamically

Note: The performance data for each salesperson must be read from a
text file.

Thanks in advance,
Prasad

 

[Prasad Vanka]

Hi,

Can someone guide me in the right direction for the problem below.

Thanks in advance
Prasad Vanka

 

[Prasad Vanka]

Hi,

Can someone guide me in the right direction for the problem below.

Thanks in advance
Prasad Vanka