Help with bar graph

[SCBankerTim]

I’m using Excel 2010 and Windows 7.

I need help in how to set up a bar graph. On the Y-axis I’d like to have the months of the year (Jan, Feb, Mar, etc.), the X-axis needs to be my data sets (Service Charges, Non-Interest Expense, Net Income…all YTD figures). I’ve already calculated where I’m at to goal on my X-axis data sets. For example, my YTD budget for Net Income is $1000, and as of May I’m at $480, or 48% to goal.

I want my graph to show that YTD Net Income in May is 48%, which exceeds the May target of 42% (5 months into the year is 42%). I’d like to also have a line at the 42% level on the graph so it would be easier to see what is above and below goal.

For info purposes, here is the data I’m working with:

Service Charges: 41.3%
Non-Interest Expense: 37.6%
Net Income: 48.3%

Appreciate any help you can give.

Thanks

 

[SCBankerTim]

Here's the deatiled data if it helps. I would only need to graph the May data. I will update again for subsequent months.

	Target	Service Charges and Fees	Mortgage Income	Wealth Income	NIE	Net Contribution
January	8.33%	8.27%	10.43%	9.86%	8.35%	9.37%
February	16.67%	16.01%	18.04%	17.19%	15.48%	17.83%
March	25.00%	24.40%	26.25%	25.87%	23.64%	27.05%
April	33.33%	32.88%	35.89%	35.59%	30.93%	37.29%
May	41.67%	41.29%	44.28%	46.81%	37.59%	48.26%
June	50.00%
July	58.33%
August	66.67%
September	75.00%
October	83.33%
November	91.67%
December	100.00%

<colgroup><col span="2"><col span="4"><col></colgroup><tbody>
</tbody>