 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / April 2008PM'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? 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 _______ > I'm working in Excel 2003 and need to create a chart to show one column > per [quoted text clipped - 3 lines] > year. > I will need this for three Project Managers. HELP? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.