View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Prasad Vanka Prasad Vanka is offline
external usenet poster
 
Posts: 28
Default How to create a bar chart from a text file? Help needed please

Hi,

Can someone please guide me in the right direction? I don't know how
to start this?

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