Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bar Chart in Excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bar Chart in Excel
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bar Chart in Excel
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy chart formatting and chart templates in Excel 2007 | Charts and Charting in Excel | |||
Excel 2007 Chart - determining the color of a chart style | Charts and Charting in Excel | |||
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Charts and Charting in Excel | |||
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Setting up and Configuration of Excel | |||
Excel 2003: How to nudge a chart element or shape on a chart? | Charts and Charting in Excel |