| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
PM's Goals & Actual
I'm working in Excel 2003 and need to create a chart to show one column per
project manager. I would like to show the PM's monthly goal and what the PM actually billed in one column per Project Manager for each month of the year. I will need this for three Project Managers. HELP? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
PM's Goals & Actual
Make three columns: PM Name, Actual, and Goal. Select the data and make a
clustered column chart. Format the Actual series to have a fill color but no border, and the Goal to have a medium or thick border and no fill. Then on the Options tab of the format series dialog, choose 100 for the overlap. The Goal will be an outline, and you can easily see how much the actual has filled or exceeded the outline. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "LRW" wrote in message ... I'm working in Excel 2003 and need to create a chart to show one column per project manager. I would like to show the PM's monthly goal and what the PM actually billed in one column per Project Manager for each month of the year. I will need this for three Project Managers. HELP? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A form to keep track of monetary goals for dated events and offeri | Excel Discussion (Misc queries) | |||
| Lookup, looking up one row above the actual row | Excel Worksheet Functions | |||
| Add Sales Goals to Sales Report in Pivot Table | Excel Discussion (Misc queries) | |||
| how do I create a relational "Goals List" using Excel? | Excel Discussion (Misc queries) | |||
| Budget vs. Actual | Excel Discussion (Misc queries) | |||
Linear Mode
