I am looking for an example to help me to be able to accomplish a task.

I have an excel spreadsheet that contains the following information:

column A - team member names
col B - January budget amount
col C - January actual amount
col D - Feb budget
col E - Feb actual
the rest of the columns contain budget and actual for the rest of the year.


I am having trouble using the chart wizard to create what I want.

The purpose of my chart is to show easily how each team member is exceeding
budget numbers across the year. The chart wizard gives me a legend with lots
of colors. I dont want the legend or the numerous colors.

I would like the team member names going down the vertical axis and would
like budget in one color and actual in another color --- or--- budget shown
with a bar and the actual shown with a line. It is separating the budget and
actual bars. I would like the budget and actual for a person right next to
each other. I would like to see the months highlighted or labeled somehow.

Maybe there is a better way to show this. I am new to charting in excel so
any advice on a better way to show this would be appreciated.

I would love to have examples or instructions on this.
Thank you so much for your time.

--
Leila