Chart to show monthly goal and actual

[lvf331]

I'm trying to create a chart for business areas and plot the constant monthly goal and the business area actual numbers in a line chart. I have the actuals charted but I'm unsure as getting the straight horizontal constant for each business area.

 

[xenou]

You can try the technique shown here (I've implemented this a few times and it's quite nice. Jon also has a link to download sample files at the end of the tutorial):
http://peltiertech.com/Excel/Charts/AddLineHorzSeries.html