PM's Goals & Actual

L

LRW

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?
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables. 0
Work Budget Salary vs Real Time Salary 0
How to implement two shifts per day with multiple teams 0
Employee Schedule not plotting properly - chart type / data series not correct 0
Calculate the median value before a specified list 0
Changing Project Ownership 1
Best way to show this on a graph? 3
Assigning an overarching owner to a task 0

Top