Best chart for multiple baselines

[niravrph]

Hi All,

I have the following information. Can someone please help advise me which Excel Chart or Graph would be best suited to graph each city's baseline (i.e. target) sales goal -- and the actual results, on a per month basis?

I am using Excel 2007.

Baseline Goal Jan-11 Feb-11 Mar-11
New York 4.0% 4.2% 4.2% 3.9%
Philadelphia 4.7% 4.6% 4.6% 5.0%
Houston 11.9% 12.0% 12.2% 12.2%
Atlanta 6.5% 5.9% 6.0% 6.5%
Chicago 8.6% 7.7% 8.2% 9.0%
Los Angeles 4.4% 3.9% 4.4% 4.4%
Boston 6.9% 7.1% 8.5% 7.7%
Minneapolis 7.6% 7.1% 8.2% 7.1%


THANKYOU!
NIRAV

 

[Steve=True]

You probably need something like a bullett graph:

Explains the chart type:
http://www.perceptualedge.com/blog/?p=217

Here is how to do it in excel:
http://www.exceluser.com/explore/bullet.htm

let me know if you need help in the implementation.