I need some help with a chart.  I want a bar chart showing employees 1 - 5 and their actual performance and what the expected goal is.  The actual performance is easy enough to get but what I am having problems with is I want the goal to appear only once as a horizontal line across the bars that shows the goal is 75%.  That way they can see who exceeded the goal and who is still below the goal.  If I use both data columns in a bar chart, each employee ends up with 2 bars (one for actual and one for goal).  I don't want that.  A line chart is the closest I can get but my employer wants a bar chart.  Does anyone have any suggestions?

ID	Actual	Goal
1	68.6%	75%
2	69.4%	75%
3	72.7%	75%
4	67.5%	75%
5	93.9%	75%

Edited by PAlexander - 02 Jan 2010 at 12:12pm