Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to create dbase file from text file? | Excel Discussion (Misc queries) | |||
how to create a jpeg file from Excel Chart | Charts and Charting in Excel | |||
how to create a chart of a sheet from a xsl file that is on a url | Charts and Charting in Excel | |||
Chart data file lost - need to re-create from chart? | Charts and Charting in Excel | |||
Create text file | Excel Discussion (Misc queries) |