Goal Area

[wcurtis]

How do I add an area to a 2007 chart that shows the goals we are trying to
acheive?
I have a column chart with twelve months and need to have a horizontal
shaded bar that shows the goal are we are trying to stay in.

Thanks

 

[Andy Pope]

Hi,

The concept is the same in xl2007.
http://www.andypope.info/charts/averageline.htm
http://peltiertech.com/Excel/Charts/AddLine.html

Cheers
Andy

 

[Herbert Seidenberg]

Excel 2007 PivotChart
With horizontal shaded limit bars, not lines.
Superimposed charts.
http://www.mediafire.com/file/tjtmzhjmzri/05_13_09.xlsx