Goal Area
 

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

Goal Area
 

Hi,

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

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"wcurtis" wrote in message
...
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

Goal Area
 

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