Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code to create dbase file from text file? Hilton Excel Discussion (Misc queries) 0 October 9th 08 10:37 AM
how to create a jpeg file from Excel Chart Texas Tonie[_2_] Charts and Charting in Excel 1 November 7th 07 05:17 PM
how to create a chart of a sheet from a xsl file that is on a url Perdizes Charts and Charting in Excel 0 June 6th 07 05:33 PM
Chart data file lost - need to re-create from chart? LostExcelData Charts and Charting in Excel 1 June 7th 06 07:54 PM
Create text file Rob Excel Discussion (Misc queries) 4 June 1st 06 01:03 AM


All times are GMT +1. The time now is 07:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"